Import/Export and DB bloating

J

Jim Burke in Novi

I've noticed that when I do Imports of Excel spreadsheets or text files, and
possibly Exports as well, I end up with quite a bit of database bloating. Is
there possibly an Access parameter that is set somewhere that is causing
this, or is this just normal behavior?
 
C

Chris O'C via AccessMonster.com

If you're saying the db gets bigger after importing, that's normal. If
you're saying you compacted, then imported, then compacted again and the
second compaction resulted in a noticeably smaller file than after the import
finished, that's still normal if you're using dao. Otherwise, not normal.

Chris
Microsoft MVP
 
Top