Excel file that I export from Access is extremely large

[Ronald Mcdonald]

I wanted to try formatting an excel file that gets spit out by my Access program so I didn't have to make manual format changes in Excel. I got good results and all, but the excel file that is created is EXTREMELY large. The original excel file, without any auto-formatting from me, is about 60 KB. This file is about 10 MB.

All I did was color the headings grey, set the text in the headings (first row) to bold, and fix column widths. This is done in all 4 tabs. The workbook has a total of maybe 100 records....not even. Why would this make the file so large?

What can I do to prevent this?

[June7]

Provide the code you are using.