Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 68
  • Last Modified:

Access Text File Export Results in Very Large File size

Hi everyone, this might sound like a weird question, but here goes.

I have a table that I'm exporting from access to a fixed width text file with specifications indicated for column width and start position. The table has about 19000 rows and it has about 166 columns; however only about 40 % of the columns are filled in.

When I go to export the table to the text file, the result is a text file that looks 100% correct, but the file size is over 300 megs!  The same file created by our old system resulted in a file that was about 10 megs. I'm trying to figure out why access would create such a large text file in size?  I've already compacted and repaired the database and had no luck. Does anyone have any suggestions on other things to try?

Thanks in advance.
0
Anthony6890
Asked:
Anthony6890
  • 6
  • 2
  • 2
  • +1
1 Solution
 
bfuchsCommented:
do you still have copies of the old files, if yes try compare some records and see whats the diff, perhaps just copy a few records so it would be easier to determine.
0
 
Anthony6890Author Commented:
I did compare the files today.  The only thing I could notice is that the fonts were different, so maybe there has something to do with the encoding coming out of access?
0
 
aikimarkCommented:
what does the schema.ini file look like?
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.

 
Gustav BrockCIOCommented:
Fonts?

Don't export to Word (rtf or html) but export to text (.txt).

/gustav
0
 
Anthony6890Author Commented:
Aik, I will check the schema either today or tomorrow. I don't have access it to this morning because of network maintenance going on.

Gustav, I am exporting it to a txt file. I just noticed that the text itself does look a little different compared to the original files.
0
 
Gustav BrockCIOCommented:
.. the text itself does look a little different compared to the original files.
A little? In what way? From 10 MB to 300 MB there must be a huge difference.

And this:
The only thing I could notice is that the fonts were different
For plain text files, fonts are not different. There is and can't be no font specification.

/gustav
0
 
Anthony6890Author Commented:
Hi Gustav, I believe you are correct about the file size.  Before, the old files had a limitation of only 7 instances of a specific field (dependents of an employee).  I can no capture about 14 dependents which has changes the file length size from 13700353 bytes to 298225270 bytes which would explain the increase size difference...
0
 
aikimarkCommented:
Especially bad if you have fixed width fields
0
 
Anthony6890Author Commented:
Hi, yes the text file that I export, is a fixed width file with specifications for the column start and the width of the column itself...
0
 
Anthony6890Author Commented:
When I compared the size of the original files I had with the ones I've created, the new ones are 21 times the length compared to the old ones.  Has anyone ever heard of access adding extra padding to fixed width files?  Something just doesn't seem correct...
0
 
Anthony6890Author Commented:
The filesize increase was specifically because of the fixed width layout.
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 6
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now