<div>
The Excel data does not have appostrophes. &nbsp;Both Excel and Access fields are defined as text.<br />
<br />
Example:<br />
Excel data = 00055239<br />
Import to Access = 55239
</div>


The Excel data does not have appostrophes.  Both Excel and Access fields are defined as text.

Example:
Excel data = 00055239
Import to Access = 55239

Access--EEQ-23906504-2007Leading.zip

<div>
<div class="content wysiwyg-content">
I'm trying to import Excel 2007 data into Access 2007 - one of the fields requires leading zeros. &nbsp;The import data shows the leading zeros in a text field. &nbsp;Access is also defined as a text field and is dropping the leading zeros. &nbsp;This process worked fine with Office 2003 software.<br />
<br />
I have tried to format the text field in Access. &nbsp;I can type in the leading zeros or do a replace which saves the leading zeros, however, Acess deletes the leading zeros when imported.<br />
<br />
Example:<br />
Excel data = 00055239<br />
Import to Access = 55239<br />

</div>
</div>


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.

Example:
Excel data = 00055239
Import to Access = 55239


Importing data from Excel 2007 to Access 2007 - dropping leading zeros in text field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.