Import/Export and DB bloating

[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?

 

[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