Hello,

I am by no means an expert / teach myself as I go, so please keep that in mind. I have created code to either create a new or update an existing access DB using ADODB through VBA for Excel. Everything works perfectly, but the resulting database files are very large (26MB). They can be brought back down to normal size (1MB) using the Compact/Repair feature within Access, but that's very inefficient/time-consuming. Can anyone take a look / offer some suggestions? Relevant code is posted below. I'm also open to any other suggestions on the code in general if something looks inefficient.

Thanks!!

Please Login or Register  to view this content.