MS ACCESS 2000 AND ACCESS 97

[Guest]

I can import from a .TXT FILE semicolon deliminated data and it works fine..
ACCESS 2000 give me an import error that the row is too long 65000 and just
garbage ... is there an import setting qualification criteria?

 

[John Nurick]

Hi Gene,

One possible cause is that your textfile doesn't have the standard
Windows newlines (CR+LF) but uses just CR (like Apple Macs) or just LF
(like Unix/Linux). Access 97 was more forgiving about this than Access
2000. If you don't have a hex editor to check this with, try opening the
file in Notepad and saving it under another name - or download one of
the many conversion utilities to be found on the internet.

 

[Guest]

Thanks John, but I had just figured out my problem... when importing I got a
single garbled line ... I went into ADVANCE and saw it was coming thru as
UNICON and not US-ASCI.... once I selected the US-ASCI and other criteria it
worked fine ... I need to find out how to default it to the US-ASCI..

Thank for you feed back..