Hi Dave,
Not really, except that the 2GB limit on the size of an mdb file
necessarily limits the amount of data you can import into it.
If the file is more than 10 or 20 MB it's probably best to create the
table manually first with the necessary fields but no indexes; then
import the data and finally create the indexes. This seems to makes the
import process faster and safer and (I think) reduces the demands on
file size, temporary disk space and memory.
With files of several hundred megabytes the 2GB limit becomes a real
concern. Fortunatly one seldom if ever needs to import all the data in
the file but only selected fields or records: these can be extracted
with text file tools to create a smaller, more manageable text file to
import.
There are also limits of 255 fields per table and 2000 characters per
record (excluding memo and OLE fields); these can be evaded by
restucturing the data while or before you import it.
