'Does Not Contain Data'

L

lk

I'm trying to load in a very large .csv file. There are approximately 3
million records and about 400 characters per line.

When I try to link this file to think this file to my access database (File
--> Get External Data --> Link Tables) I get a Link Text Wizard error that
says:

File 'C:\EOM.csv' does not contain data.

I should also note that this file is too large to load into notepad.

Any suggestions?
Thanks-
 
J

Jerry Whittle

If I'm doing the math properly, that should be around 1.2 GB of data. That
should squeeze into an Access mdb file. Try importing it into a new database
then linking to it there.
 
L

lk

Hi Jerry,

Thank you for the reply. I'm actually just linking the file (Link Tables).
But just for kicks I tried your suggestion but I got the same error message.
 

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

Link File 1
Linking Access to selected fields in a large external table 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Unable to import CSV file 2
Count field length in delimeted file and compare with predefined listof field length 8
Link File 2
File does not contain data??? 2
Access Can Not Export Large Table? 3

Top