I have a .csv file that has data in it that contains symbols such as " © ®
When I either 1) link to the file 2) import the file, Access trashes those characters and replaces them with garbage characters. How can I get Access to read these correctly?
Access has no problem with these symbols when they are entered into an Access table, just in .csv files. I can convert the csv to Excel, and Access can read them but 1) Excel ruins the zip codes and 2) I don't want my end users to have to spend the time converting a bunch of .csv files every two weeks.