Importing Large Text File

M

Marianne

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

Ken Snell [MVP]

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Excel Data Into MS Access Memo Field 2
problems importing a Paradox file into Access 2003 4
Importing Problem 1
Import errors importing Text into existing table, header vs no hea 3
Exceeding File Size During Import 4
Formatting 900,000 rows 6
Importing large text file to version 2003 versus 1997 3
Search Key Not Found Error 2

Top