469,927 Members | 1,735 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

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

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
2 3761
kejeff
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
RRoma
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.

Similar topics

4 posts views Thread by Little PussyCat | last post: by
2 posts views Thread by Don W. Reynolds | last post: by
9 posts views Thread by jillandgordon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.