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

transefing data from excel to access

P: 1
Hi!

I just need a little help finding out how to display the numbers that i import from excel with 0 in the front. Example: i got a number 00000023456 and it only displays 23456 and that is why i have duplicate values.

Thanks,
J
Sep 5 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 126
Hi!

I just need a little help finding out how to display the numbers that i import from excel with 0 in the front. Example: i got a number 00000023456 and it only displays 23456 and that is why i have duplicate values.

Thanks,
J
Insert a new row at the top of the spreadsheet, and fill the reference field with "test", this will cause access to recognise that field type as text instead of a number, and so the leading zeros will be retained. Once it has imported, simply delete the first (test) record.
Sep 5 '07 #2

Post your reply

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