Exclude foreign characters from text import

[Guest]

I have imported a text file into a table that contains characters such as â•“
and ┼. I tried writing a query with criteria to exclude such characters:
Not like "*â•“*" However, the resulting rows still include fields with these
characters. How do you exclude foreign characters in your query result?

Thanks,
Melanie

 

[John Nurick]

Hi Melanie,

In general it's preferable to work out why characters from the text file
aren't being imported (or displayed) correctly, and fix it at source.

Things to try:
1)If you're using Access 2000 or later, make sure that you're using a
Unicode font such as Arial Unicode MS. That maximises the range of
characters that can be displayed.

2)If (1) doesn't solve the problem, leave the Unicode font in place and
re-import the text file. As you work through the import wizard, click
the Advanced button and select an appropriate-seeming code page
(character set). One of these should give correct results.