Importing a file

[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.

 

[John Nurick]

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.

 

[John Marshall, MVP]

I've been doing 750,000 line files with no problems. The only issue I have
found coming from a mainframe is that the "[" and the "]" do not translate
properly.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm