No backup needed. This is a pre-sales job. I want to demonstrate that I can convert their data.

They like their customer numbers and want to keep them. These numbers are used in their external POS systems (this is a small chain of grocery stores). The POS system keeps 'house' accounts and exports charges to said accounts to a text file daily. We will import these charges and age the house accounts in Adagio. But we need to keep the customer account numbers with their leading zeros.

How about importing from a quote-delimited, comma-separated value file. If the customer number in the CSV is "000001", will it import with the leading zeros intact?