Importing Large Text File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marianne - 22 Sep 2004 21:50 GMT

Can I import into Access a .txt file with approx 900,000
records (rows) into Access.

The File Size is 210 MB (220,216,158 bytes)

This text file was so large it would not open. So I was
unable to look at the data contained in the file.

Reply to this Message

Ken Snell [MVP] - 22 Sep 2004 22:12 GMT

Should be able to do that, so long as there are not more than 255 fields in
each record.

Signature

Ken Snell
<MS ACCESS MVP>

> Can I import into Access a .txt file with approx 900,000
> records (rows) into Access.
[quoted text clipped - 3 lines]
> This text file was so large it would not open. So I was
> unable to look at the data contained in the file.

Reply to this Message