Error when trying to use a text file with two columns as a data source

Hi!

I'm getting errors when I try to use a text file of 2.99 GB as data source. I get an error message telling me the file contains no data, even though I can open the file in other applications.

Looking forward to any hints on what may be causing this.
Evert JorDVM/ResearcherAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Evert JorConnect With a Mentor DVM/ResearcherAuthor Commented:
Hi Cactus_data.

The number of records is to large for MS Access. The number of maximum records is approx. 255 000 (or a bit less). If you use blobs to store data this will make it possible to store more than 2.99 GB. My problem is to many records. That is why it's not possible to import it in chunks either.

Connecting to an external database with higher capacity will often solve it. Did you get that?

The problem now is that that doesn't work either.
0
 
Gustav BrockCIOCommented:
Try splitting that big file in some smaller chunks and import/attach one by one.

/gustav
0
 
JVWCCommented:
Some discussion here may assist:
http://www.experts-exchange.com/Databases/MS_Access/Q_21306710.html

Are you trying to import the data, or as your question suggests, using this as a data source?
As Cactus data suggests, splitting this into smaller chunks may reveal your problem.

Cheers
JC
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jeffrey CoachmanMIS LiasonCommented:
Yes, please clearly describe specifically what you me when you say: " I try to use a text file..."
"*Use* a file"?
Use a file how? in what application, ...etc
0
 
Evert JorDVM/ResearcherAuthor Commented:
Hi boag2000. The information you request regarding details of which application I use is listed beneath the question, as well as above. Data source can mean numerous things. In this case it is simply a plain text file with two columns containing data.
0
 
Evert JorDVM/ResearcherAuthor Commented:
Hi, sorry for the delay.

It is a 2.99 GB text file containing data. When I'm trying to use the "Connect to datasource" I get the error. I'm not trying to import the data into access since there is a maximum limitation on the number of records in Access.

I will try it in the 64 bit version of Access instead to see if that works.
0
 
Gustav BrockCIOCommented:
I believe my original comment is still valid.

Copy a small portion of the file - some hundred KB - and import/attach that.
If it works, your issue is a too large file for Access.
If it doesn't, you will have to adjust the file somehow, no matter the size/length of it, until success. At that point, try with the full file (modified). If that fails, you are back to my original comment.

/gustav
0
 
JVWCCommented:
I tend to agree with CD, file size is most likely the issue.
Is your data file csv or txt, or some other format?
Can you also elaborate on "Two columns of data"

Cheers
JC
0
 
Gustav BrockCIOCommented:
> The number of records is to large for MS Access.
> The number of maximum records is approx. 255 000 ..

No. Access can easily handle that count of records. Problem is the total file size which - as you have seen - Access can't grasp.

You still haven't told if the simplest solution - to split the file into smaller chunks - works for you.
Of course, importing/attaching the file to, say, SQL Server may present a work-around but that was not your original question.

/gustav
0
 
Evert JorDVM/ResearcherAuthor Commented:
Experience.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.