I'm importing data into Access on a daily basis. The data in one of the tables ("InvoiceLine") is too big.
The command I use to import the table (by macro) is:
DoCmd.TransferDatabase acImport, "ODBC", ODBCConnectStr, acTable, "InvoiceLine", "InvoiceLine", False
This grabs/imports all 270,000 rows from the source database table. This causes the Access database to balloon to over 2.0gb and I end up having issues compacting. Additionally, there are sometimes issues during the import.
I'm wondering if it would be possible to run a similar command with a Query attached so that only transactions with a (date > (today - 180 days)) - or do I have to import everything and then trim the database?
Thanks for your help!