Import errors

bknight
BronzeLounger
Posts: 1463
Joined: 08 Jul 2016, 18:53

Import errors

Post by bknight »

I have a rather bizarre question. I imported some records into a Db and determined that some of the records were incorrect in the spreadsheet, so I deleted all of the imported records. After fixing the spreadsheet, I reimported the data. I looked over the records and found several duplicates that aren't in the spreadsheet. Do I have to repair and compact the Db after the deletion operation?

User avatar
HansV
Administrator
Posts: 78794
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Import errors

Post by HansV »

I cannot explain that, but it never hurts to compact and repair your database.
Best wishes,
Hans