Exporting problem excel to access

[sap1958]

Using MS Access 2000 and excel. I have a column in excel that excluded some leading zeroes. I added them by doing the following:
format-custom. I then typed 10 zeroes and got the records to format correctly (ie 0000051647, 0AA0512251 ) However when I bring the file into acess, the leading zeroes are suppressed. I checked to ensure that the data type is text. How can I format this to transfer the records to include the leading zeroes. or is best to handle this in an access query. If so how would I set up the query in access?

 

[SkipVought]

hi,

faq68-6659

Formatting changes [red]NOTHING[/red]. Your underlying NUMERIC value is 51647.

You must CONVERT your NUMBER to a STRING, with however many leading zeros you need, per the FAQ.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}