By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,827 Members | 2,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,827 IT Pros & Developers. It's quick & easy.

Importing From Excel to Access (W/O Losing Preceeding Zeros)

P: 2
Does anybody know how I can import lists of numbers from Excel into Access without losing the preceeding Zeros??? The field must have a total of 10 digits.... Is this a function of how its saved in Excel?? I can bring the data in if its saved as a Text File in Excel, but I want to be able to Import an .xls File without losing data.... I've tried Importing and it always drops the Zeros... I've tried Linking, and it brings in the exact numbers with the zero's preceeding but when you create a Table it drops them all out again...


OR... Is there a way to change Access to show Zeros in the Field Format.... I've worked with all the updates with no avail.....Please Help......................
Sep 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: 3
Does anybody know how I can import lists of numbers from Excel into Access without losing the preceeding Zeros??? The field must have a total of 10 digits.... Is this a function of how its saved in Excel?? I can bring the data in if its saved as a Text File in Excel, but I want to be able to Import an .xls File without losing data.... I've tried Importing and it always drops the Zeros... I've tried Linking, and it brings in the exact numbers with the zero's preceeding but when you create a Table it drops them all out again...


OR... Is there a way to change Access to show Zeros in the Field Format.... I've worked with all the updates with no avail.....Please Help......................
The leading zeros in Excel are read as text data type. Either create a formatted table which contains a text field, or create an import specification using the import wizard to set the spec to repeat the importation. In some cases, copying the data from Excel using the clipboard, pasting into a preformatted table will make quick work of moving your speadsheet into Access.
Sep 14 '06 #2

P: 2
The leading zeros in Excel are read as text data type. Either create a formatted table which contains a text field, or create an import specification using the import wizard to set the spec to repeat the importation. In some cases, copying the data from Excel using the clipboard, pasting into a preformatted table will make quick work of moving your speadsheet into Access.

Thank you very much for responding to my question. I worked the data some more and I have realized that some of my data my be corrupt..... I imported some other files with similiar data and it appears to be working......... Once again, I really appreciate the support and response........

Thanks,
rroma
Sep 15 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.