Syntax Error In Create Table Stmt.

[Liz]

I have a user that is importing a very large .txt file
into access. When he imports it he receives a the
following error: syntax error in create table stmt.
The data will not pull in, however I can pull it into
excel. Any ideas why it isn't working in access?

 

[John Nurick]

Hi Liz,

I've never encountered this error myself, and a web search found no
trace of it occuring when importing text files into Access in the normal
ways.

IME most problems importing text files turn out to be due to
inconsistencies in the structure of the file (e.g. a line with the wrong
number of delimiters, linebreaks other than CR+LF).

Is the user doing a straight File|Get External Data|Import, or is there
custom code involved? If he splits the file into two or more pieces, do
they import OK, or do some fail and others succeed (if so, look for
inconsistencies in the structure).