Hi Gordon,
> I have to import some data from an Excel spreadsheet into an Access
> application.
>
> One of the cols is in the following format.
>
> eg
>
> 2925
> 240
> 249
>
> The original data source had these like so
>
> 002925
> 000240
> 000249
>
> I would prefer to reinstate these leading zeros. These are and
> will be a Unique key Index. The original source allows export to
> Excel but when copying into Excel removes the leading zeros:)
>
> This is a monthly update requirement and it may be that some time
> in the future we will need to use these numbers to link to other
> sources using this field as the link hence my need to keep the leading
zeros.
>
> Any and all suggestions received with the usual enthusiasm and gratitude!
>
Try exporting form Excel to a CVS (comma separated values) file, from that
file import into Access but be sure to set that column to Text and not
Numeric. That should allow you to import with the leading zeros...
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
