Invalid Argument Error

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?
 
J

John Nurick

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.
 

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

Top