IMPORT DELIMINATED TXT OK IN ACCESS 97 SAME IMPORT TXT IN 2000

G

gene w

Importing a deliminated semi-colon .txt file works ok in access 97.. same
import to access 2000 is bad .. seems it is one line of garbage .. did a
default change?
 
G

gene w

I answered my own question ... when importing I got garbage but when I went
to advanced and specified US-ASCI ... delineated etc ... I got the results I
was looking for ..... seems the default was 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

Access 2003: Import Extensionless Files 3
ht change default directory for import/export 0
Import txt-files using Wild-cards in file_name 6
Read .TXT file line by line? 12
Change dot to a comma in .txt file 1
Import and Append of txt files 1
Import Multiple Tables 1
importing from a *.txt file 4

Top