Leading Zeros Problem

[mmmgood1]

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]

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.