Leading Zeros Problem

[mmmgood1@yahoo.com]

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.

[Trevor Best]

Re: Leading Zeros Problem

On 18 Nov 2003 09:07:02 -0800 in comp.databases. ms-access,
mmmgood1@yahoo. com wrote:
[color=blue]
>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.[/color]

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.