I have MS Access File with a file size of 1.7GB. I have already tried to compact and repair, but the file size remains the same.
This is what I did. I download about 29 files from jupyter python to excel and csv files. The total amount of data is about 934MB.
I need to update the data everyday, therefore I linked the Access file to all the exported files under linked table and create another table to have a relationship with each other. So I have 2 tables for each exported file, for example: customer_linked and customer.
And this is the step by step of query:
1. Delete query for all data in non-linked table
2. Append query to append the linked-table to non-linked table
I have no idea that this way, it will make the file super bloated to 1.7GB. Is there any way to make it smaller?
You can look into converting the excel files into csvs if you're looking to try and save space. Depending on how large the files are, there might be a lot of bloat in the excel files, full of extra stuff you don't need. If you're not using the excel files for images/graphs/formatting of some kind then you're best off just converting them all to csvs.
MS Access Big File Size Problem with exported file from Python