Unable to Load A Text File

LynneM1

New Member
Joined
Dec 14, 2006
Messages
41
Hello,
I received text files and as I usually do tried to link to them. The result was this message:

does not contain data, or the file is too large

I reduced the size of one of the files to a few lines and recieved the same message.
I Compacted and Repaired the Database and tried again - same message.
I created a blank database using Access 2007 and tried to import the data -same message.
I tried to import past text files that I had no problems with - same message.

Does anyone have any idea what is going on here?

Any help is greatly appreciated.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,658
Office Version
2016
Platform
Windows
As a beginning suggestion can you open the file in Excel as a CSV file and does it add the delimeters?

Also check out the MACRO section about transfertext and look at the arguments below about importing it.
 

LynneM1

New Member
Joined
Dec 14, 2006
Messages
41
Thanks for responding. These files are very large that is why I have to link to them. Plus I just tried to import an Excel file and received the same message. What is weird is that I never had a problem doing this before and I had the sender test importing the files in his Access 2007 and he had no problem.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,178
Office Version
365
Platform
Windows
What kind of text files are they? Delimited or Fixed Width?
What is the approximate length of each record on your text file?
 

LynneM1

New Member
Joined
Dec 14, 2006
Messages
41

ADVERTISEMENT

Hi,
Thanks for trying to help, but this data is not any different and I am using old files for testing so the set up of the files is not relevent. There is something wrong with my software I think. If anyone else has experienced this can you please let me know. Thanks
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,178
Office Version
365
Platform
Windows
It is very hard to provide help if you do not provide details to the questions we are asking.

If it worked in testing and it doesn't work now, the three most likely possibilities are:
1. you have a corrupt database (probably not the case, as you rebuilt it)
2. something changed with your data file
3. soemthing changed with how you are performing the task

Importing and Linking can work very differently depending upon what kind of text files you have, as when you import you tell Access exactly what the delimiters are or how long each field is. For a Fixed Width text file, I am not sure how Access knows that if you are just linking them. So I am trying to get a feel for how you are doing this, and if it seems correct.
 

SRienstra

New Member
Joined
Dec 3, 2009
Messages
14
I am running into the same error message when attempting to use the CMS NPI file (3.5GB), so I suspect that the OP's problem is likely to be that the file is larger than those previously tested.

This thread has a potential solution, as does This link, though I have not yet tested either myself.

Edit: Upon re-reading the initial post, I am curious as to the number of fields in the file. Have you changed from using SQL Server as the engine to Jet? Otherwise I am stumped as to how you previously succeeded.
 
Last edited:

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,600
Messages
5,512,336
Members
408,886
Latest member
kashifziatevta423

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top