Size of Excel file Access db exports to.

I have an Access db that exports about 350 queries to a specific Excel file. This is done on a weekly basis then monthly basis. The db and exporting works great. However the size of the file. The size of the file after the save is as large as my largest month of data which makes sense. Is there anyway to compact an Excel file like you can in Access to get reclaim space that may be used in the monthly data but not in the weekly data? The weekly data was making the file about 26 MB. After I ran the monthly data it ballooned to 36 MB.

All but about 20 of the queries are created through code. Would it be best to duplicate the code and have monthly run to one file and weekly run to a different file? (The size of the db is not a problem its only about 400 kb after compact because the data is kept in another db and just linked to.)

Finally, I know that an Access db has a size limit of about 2 GB. Is there a size limit to Excel.

I have never seen "Compact" in Excel but my suggestion is that you should
ask this in one of the Excel newsgroups rather than Access newsgroups.

--
HTH
Van T. Dinh
MVP (Access)



"Tasha" wrote in message
...
I have an Access db that exports about 350 queries to a specific Excel
file. This is done on a weekly basis then monthly basis. The db and
exporting works great. However the size of the file. The size of the file
after the save is as large as my largest month of data which makes sense. Is
there anyway to compact an Excel file like you can in Access to get reclaim
space that may be used in the monthly data but not in the weekly data? The
weekly data was making the file about 26 MB. After I ran the monthly data it
ballooned to 36 MB.

All but about 20 of the queries are created through code. Would it be best
to duplicate the code and have monthly run to one file and weekly run to a
different file? (The size of the db is not a problem its only about 400 kb
after compact because the data is kept in another db and just linked to.)

Finally, I know that an Access db has a size limit of about 2 GB. Is there
a size limit to Excel.

Hi
see: http://www.contextures.com/xlfaqApp.html#Unused

This may help a little bit (there's no 'compact Excel' feature)


--
Regards
Frank Kabel
Frankfurt, Germany


Tasha wrote:
I have an Access db that exports about 350 queries to a specific
Excel file. This is done on a weekly basis then monthly basis. The db
and exporting works great. However the size of the file. The size of
the file after the save is as large as my largest month of data which
makes sense. Is there anyway to compact an Excel file like you can in
Access to get reclaim space that may be used in the monthly data but
not in the weekly data? The weekly data was making the file about 26
MB. After I ran the monthly data it ballooned to 36 MB.

All but about 20 of the queries are created through code. Would it be
best to duplicate the code and have monthly run to one file and
weekly run to a different file? (The size of the db is not a problem
its only about 400 kb after compact because the data is kept in
another db and just linked to.)

Finally, I know that an Access db has a size limit of about 2 GB. Is
there a size limit to Excel.