Access Text File Export Results in Very Large File size
Posted on 2016-11-10
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.