I am using an ADO connection to move data from one MDB file to another. I create SQL statements "on the fly" and use the ADOConnection.Execute(sql) method to do the actual data move.
In one scenario the source database is about 150 megabytes. After the data has moved to the destination, the destination's size is 370 megabytes. Compacting and restoring returns it to 150 megabytes.
In a second scenario the source database is about 4 MB and the resulting destination database is 20 MB.
What is going on? Is there any way I can move the data without getting such a large increase in database size?