Link to .csv table Corrupt

A

aleon

When I create a link to a .csv table that includes names that have accents,
it changes the accents to letters or weird characters in the Access table.
I've tried through the specs using the language and code page. The database
is Access 2003. Thanks.
 
J

John Nurick

When you say "names" do you mean field names or values in text fields?

If the former, rename the fields. If the latter, you normally just need
to find the right combination of code page and font.
 
A

aleon

They are person's names with accents in them. I've just tried English with
code page "Unicode - UTF(7)" and that seems to work. Funny that it worked
before using OEM - United States. Why would it just stop working?
 
J

John Nurick

As far as ASCII characters are concerned, UTF-7 and OEM - United States
are identical, but they work quite differently outside the ASCII range
(0-127). Maybe the software that creates the csv file was updated and
now uses Unicode?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
VBA - (re-) Set a Table Style 2
Cannot import CSV file into ACCESS 1
Delimited Export Specification - independent of table 3
import csv conversion & import spec error 1
Csv import: direct link vs temp table dump 2
Invalid Argument Error when importing .csv to Linked Table 1
Export report into rft character conversion 0

Top