Trouble importing a text file

[bill_s1416]

When I attempt to import a text file, I get the error message: "File 'C:\Documents and Settings\Administrator\My Documents\SALESPROD2.TXT' does not contain data." It is a large text file, 2.14 GB. Before you say the file's too large, I did check the Access specifications and discovered the max database size is 2 GB. However, I believe this file--when imported into Access--will only be around 1.8 GB. I use as my example the SALESPROD1.TXT file which was 1.10 GB yet, after importing, created just a 811 MB Access database.

If the reason is in fact that the text file is just too darn big, then how can I get around that? Is there a way I can split up the text file first with some type of text editor that can handle huge files like that? (I don't want to have to buy and learn another database program because the report I'm working on is due in two days.)

 

[TheToeOfPooh]

Just a thought

Can you run the file through Excel first and use that to reduce the size?

HTH

Bernard