I have an text file with 700,000+ records. When I imported into Access all the accented characters were changed, but if I import into MS-SQL they remain the same. For example É shows up as Φ in Access 2000. What setting in Access can I change to reflect the proper characters?
Thanks