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

G

Guest

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

Guest

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

Import File 1
MS ACCESS 2000 AND ACCESS 97 2
Access 2003: Import Extensionless Files 3
Import txt-files using Wild-cards in file_name 6
Error import table 4
Import Text with non-txt extentions 3
Access 97 does not import .txt and HTML files 1
Import Text - Macro Issue - Semi-Colon Delimited 2

Top