Import Huge Text File

[Ken Hudson]

Hi,
I have a large text file that I got from my corporate office. It is 1.5 GB
(10 million records with 13 fields per record). The fields are dollar sign
($) delimited and are also fixed width.
When I use the Access import wiard to import the file, I go through the
wizard steps. I click on the Finish button and the file starts to import.
When I get to the end of the importing, I get an error message:

The Microsoft Jet database engine could not find the object ." Make sure the
object exists and you spell its name and the path correctly.

Any ideas what may be wrong?

Is there code that I could put into a module to accomplish this import?

TIA.

 

[Douglas J. Steele]

Given that Access has 2 Gb size limit, and a table in Access will definitely
be larger than the equivalent text file, you may be unable to import that
file into your database.

 

[Ken Hudson]

Hmmmm......
After I got the error message, I checked the file size and I saw that was
just a tad over 2GB. Even though the import had aborted, Access still had the
file space set aside. I wasn't aware of the Access limit.
Since I only really needed the first six fields for each record, I only
imported those and got the file loaded.
Thanks Doug.