Invalid Argument Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tab delimited text file with some 155 columns. When I try to import it
into an existing table using the import wizard it gives me an 'Invalid
Argument' error. But when I do the same import after converting the text file
to an excel file , it works fine. I tried to import, after the changing the
data in the text file to be of the same datatype as that in the table
specification. But even now it gives the same error but works in excel.

Any idea why this error occurs and how to avoid it?
 
Hi Pavithra,

One possibility is that the text file doesn't have the standard Windows
record separator of CRLF - Chr(13) & Chr(10). This is likely to be the
case if the file originally came from a mainframe, Unix or Macintosh
system. This doesn't bother Excel but does upset the text import routine
in recent versions of Access.

There are many utility programs that can convert the line breaks; try
downloading one and see if that fixes it.
 
Back
Top