Inport File Size

[Brian]

I'm attempting to import a large .csv file into a table
and Access seems to be locking up. Does anyone know what
the max file size access can handle inporting into a table?

 

[John Nurick]

Hi Brian,

There's no set limit. I've imported more than 200MB without problems,
though it can take a while. Possible sources of trouble:

-any inconsistency in the structure of the file. IME this is a common
cause of problems importing big text files.

-hitting the limit on the size of an mdb file (2GB for Access 2000 and
later). This can happen sooner than you expect if you're importing
hundreds of megabytes; reduce the likelihood by
-compacting the mdb before importing
-create the table manually before importing, with no indexes
except on the primary key (Access automatically creates
indexes on fields with names like "ID", "IDNum", so take
care to remove these; re-create them after importing the
mass of data).
-putting both the mdb and the text file on a local drive
rather than on the network. This speeds things up greatly
as well as removing the chance of corruption from network
glitches.