Foreign character's and accents not importing correctly

[nickjones87]

Hi guys,

I have a problem with special characters / symbols / accents not being imported correctly into access.

For example, ° or ß or é ù ü etc.

I have a macro to import the data from a Tab Delimited file using "TransferText" in the macro wizard

I am using Unicode (UTF-8) as the spec for the import. But this will simply delete any foreign character's (eg straße would become strae once imported into a table)

I have tried numerous other Code Page's without success.
When I open the same file in excel and I select Windows (ANSI) and the characters will show in excel.

Has anybody experienced the same problem, and is there a work-around?

Thanks..