Importing a CSV

[Guest]

I have a large csv file (roughly 13 milllion lines of data). I am trying to
use the import wizard. All looks fine as I move through the steps of the
wizaerd until I try and run the import.

I get the following error messages (in this order)

"Records could not be added to the exceptions table"

"An error ocurred trying to import file "my path and file name...The file
was not imported"

"Invalid Argument"

The wizard works for smaller files. Is there a limit on the size of files
that can be imported ?

If there is, is there another way to bring the data into Access ?

Thank you in advance.

 

[David Lloyd]

Carl:

What version of Access are you using?

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a large csv file (roughly 13 milllion lines of data). I am trying to
use the import wizard. All looks fine as I move through the steps of the
wizaerd until I try and run the import.

I get the following error messages (in this order)

"Records could not be added to the exceptions table"

"An error ocurred trying to import file "my path and file name...The file
was not imported"

"Invalid Argument"

The wizard works for smaller files. Is there a limit on the size of files
that can be imported ?

If there is, is there another way to bring the data into Access ?

Thank you in advance.

 

[David Lloyd]

Carl:

There is not enough information to know whether the following KB articles
apply to your situation, however, I thought I would make you aware of them.

http://support.microsoft.com/default.aspx?scid=kb;en-us;835416
http://support.microsoft.com/default.aspx?scid=kb;en-us;302495

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a large csv file (roughly 13 milllion lines of data). I am trying to
use the import wizard. All looks fine as I move through the steps of the
wizaerd until I try and run the import.

I get the following error messages (in this order)

"Records could not be added to the exceptions table"

"An error ocurred trying to import file "my path and file name...The file
was not imported"

"Invalid Argument"

The wizard works for smaller files. Is there a limit on the size of files
that can be imported ?

If there is, is there another way to bring the data into Access ?

Thank you in advance.