Link to .csv table Corrupt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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?
 
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?
 
Back
Top