Importing a file

  • Thread starter Thread starter AL B.
  • Start date Start date
A

AL B.

I would likt to import a text file which will have 2
million rows. The file is a text file ftp'd form TSO.
Has anyone heard of any limits to the number of rows you
can have in an access table. There will only be 4 columns.
 
Hi Al,

There's no set limit to the number of rows, though there is a limit of
2GB on the total size of an mdb file (including tables, indexes, forms
and everything). So provided there isn't already too much stuff in your
file it should import OK.
 
Back
Top