Disable Undo whilst importing data

[Adam Thwaites]

I'm doing some pretty big data imports into Access, and the system is killing
its self trying to enable the Undo feature through out this, to a point where
halfway through the import, it says

Your computer is out of disk space.
You won't be able to undo this paste append. Do you want to continue anyway?

I'll never want to undo, so can I just turn that feature off so it can just
get on with the import?

Cheers

 

[Klatuu]

Depending on the type of data you are importing, you should be using the
TransferSpreadsheet or TransferText or TransferDatabase methods.

 

[Adam Thwaites]

Hey Klatuu, i'm using the TransferText method to import that data

 

[Klatuu]

Really!

How much data are we talking about here?
How many fields in a record?
How many total characters in a record including all fields?
How large is the text file?
How much space is available on the disk?
What is the size of the mdb you are importing into?

 

[Adam Thwaites]

I'm importing the Royal Mail PAF data, the main address file consists of
5x600meg fixed width text files (6,000,000 records per table), aswell as
several other reference tables

 

[Klatuu]

The number of records is not an issue, but if you are saying you are
importing 5 600 MB files, that would be 1.5 GB.
I think you are going over the 2 GB limit for an mdb file.

You may need to consider upsizing to SQL Server.