Best Practices for Importing Data

[Charles Blackwell]

Hi. I just wanted to get some feedback what you thought were some of the best practices for importing data. Should I back up the table first?

Thanks.

Charles

[mr_vodka]

I think its always a good idead to always back up your file when a bunch of data is being imported. The more that is written the more of a chance of corruption. My 2 cents.

[bcooney]

Another tip is to set a global variable to Get (CurrentTimestamp) and use Replace by calc to store this in all imported records so that you can grab this batch of records if necessary.

Also, remember to reset serial numbers.