At 13:54 19/05/00 -0700 WBB said....
>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...
Thanks to all who replied.
Sorry I did not make it clear. My problem is that the original
source when exporting either to csv, wks or copy and paste removes
the leading zeros prior to writing the csv file, wks, or excel
file. It may be that this is not important but I am suspicious
that using the number without the leading zeros will mess up any
future linking using this as a key.
I am therefore stuck with trying to change three or 4 digit numbers
into 6 figures by adding zeros. If I could get the data into a
file from the original source complete with leading zeros then the
text option suggested by everyone works well.
Perhaps a RegEx that loops over the col and inserts the zeros if I
can not use a mask or formatting option in Excel?
This is once a month task to update when the new data arrives. I
think however I would prefer to undertake the Regex on the number
whenever it might be needed as a hidden formfield or URL parameter
rather than change all in advance.
Any snippets showing the most efficient way to do this would be
very helpful or other suggestions please..
Thanks
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.
