CODEWITHSUNDEEP
sqlms-accessunicodeutf-8
Hayk Melkonyan
Hayk Melkonyan

Reputation: 2150

MS ACCESS Convert to UNICODE

I have MS ACCESS DB with non unicode columns i need to import it on SQL Server How i can convert it to unicode to import?

Upvotes: 1

Views: 2653

Answers (1)

Gustav
Gustav

Reputation: 55816

You can use:

StringUnicode = StrConv(Ascii, vbUnicode)

In a query:

StringUnicode: StrConv([AsciiField], 64)

But I doubt your data are not Unicode because Access defaults to Unicode.

Upvotes: 1

Related Questions