Importing data from Excel 2007 to Access 2007 - dropping leading zeros in text field
Posted on 2008-11-14
I'm trying to import Excel 2007 data into Access 2007 - one of the fields requires leading zeros. The import data shows the leading zeros in a text field. Access is also defined as a text field and is dropping the leading zeros. This process worked fine with Office 2003 software.
I have tried to format the text field in Access. I can type in the leading zeros or do a replace which saves the leading zeros, however, Acess deletes the leading zeros when imported.
Excel data = 00055239
Import to Access = 55239