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
602
3559
252
408
417
667
2926
410
60692
The original data source had these like so
002925
000240
000249
000602
003559
000252
000408
000417
000667
002926
000410
060692
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!
Gordon
------------------------------------------------------------------------------
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.
