If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Size of Excel file Access db exports to.
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. |
#3
|
|||
|
|||
Size of Excel file Access db exports to.
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. |
Thread Tools | |
Display Modes | |
|
|