You will need to treat that field as a text field in order to
have the leading zeros. Search the archives in the last 6 weeks or
so where I described a solution...
Steve
At 06:57 PM 5/19/2000 +0100, Gordon Burns wrote:
>
>
>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.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
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.
