Hey all-
I have a DB with about 950,000 in a table called "Tallies". Within this table is information broken out by customer (about 400 of them). I currently export information for each customer to excel spreadsheets with 10 different queries. Each time I export a customers information I first move a monthly summary of their information to a table called "Cust-Tallies" using a delete and append query. After I am done exporting all of the customer information my db has bloated from 350 MB to 725 MB. I know that this is because I am moving data to and deleting data from the "Cust-Tallies" table, but my question is will it make a difference if I use a make table query instead of the delete and append queries?
Thanks,
Josh
I have a DB with about 950,000 in a table called "Tallies". Within this table is information broken out by customer (about 400 of them). I currently export information for each customer to excel spreadsheets with 10 different queries. Each time I export a customers information I first move a monthly summary of their information to a table called "Cust-Tallies" using a delete and append query. After I am done exporting all of the customer information my db has bloated from 350 MB to 725 MB. I know that this is because I am moving data to and deleting data from the "Cust-Tallies" table, but my question is will it make a difference if I use a make table query instead of the delete and append queries?
Thanks,
Josh
