469,613 Members | 1,355 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Leading Zeros Problem

Help, I'm linking an excel spreadsheet in access and I have datafields
with leading zeros (01021). When the file is linked in access, I get
a #num in the field with the leading zeros. The zeros are needed.
I've formated the field to be a text field, general number, and number
and still I get the #num! error, or the leading zero is dropped. Can
someone help before I pull more of my hair.

Thanks a bunch.
Nov 12 '05 #1
1 4287
On 18 Nov 2003 09:07:02 -0800 in comp.databases.ms-access,
mm******@yahoo.com wrote:
Help, I'm linking an excel spreadsheet in access and I have datafields
with leading zeros (01021). When the file is linked in access, I get
a #num in the field with the leading zeros. The zeros are needed.
I've formated the field to be a text field, general number, and number
and still I get the #num! error, or the leading zero is dropped. Can
someone help before I pull more of my hair.

Thanks a bunch.


Have you tried inserting about 10 blank rows at the top of the sheet?
This will fool Access into thinking they're all text fields.

I haven't tried this since Access/Excel 97 and it didn't really work
there as all the numeric fields came through as #num although things
may have improved since then, worth a try.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by david | last post: by
2 posts views Thread by r.magdeburg | last post: by
5 posts views Thread by samik_tanik | last post: by
6 posts views Thread by Clint Stowers | last post: by
5 posts views Thread by GarryJones | last post: by
6 posts views Thread by JimmyKoolPantz | last post: by
1 post views Thread by LFM | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.