Hello Fellas,
I created a procedure with the help of members of the Forum to automatically export reports from Access to Excel Files.
However, I bumped into the following obstacle. When Reports are exported, the file created in MS EXCEL 2003 is about 5 times larger than when I copy and paste the same reports manually from Access to excel.</SPAN>
Do you know what causes this? Is it because Access exports blank rows after the table? </SPAN>
Is there a way to fix it?
PS: When I convert the file form Excel 2003 to Excel 2007 the file size reverts to what it should be - five times smaller.
I have Access 2003 and Excel 2007, so currently I cannot use Access 2007 and the new Excel format.
</SPAN>
Thank you!</SPAN>
I created a procedure with the help of members of the Forum to automatically export reports from Access to Excel Files.
However, I bumped into the following obstacle. When Reports are exported, the file created in MS EXCEL 2003 is about 5 times larger than when I copy and paste the same reports manually from Access to excel.</SPAN>
Do you know what causes this? Is it because Access exports blank rows after the table? </SPAN>
Is there a way to fix it?
PS: When I convert the file form Excel 2003 to Excel 2007 the file size reverts to what it should be - five times smaller.
I have Access 2003 and Excel 2007, so currently I cannot use Access 2007 and the new Excel format.
</SPAN>
Thank you!</SPAN>
Last edited: