> 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
<cfsnip>
</cfsnip>
> 60692
>
> The original data source had these like so
>
> 002925
<cfsnip>
</cfsnip>
> 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!
OK, here's the fun thing about Excel and CSV ODBC Drivers - once it decides
that a column is numeric, it's numeric - NO MATTER WHAT!
If you have numbers in a column, then text a few rows down, the text is
ignored - the same for if the entries are textual, then numeric
You HAVE to format the cells in Excel the way you want them, then get data
via ODBC
I had the same problem a few weeks back (the reason I re-joined this list),
and have only come up with the fact that M$ Excel/CSV ODBC driver sucks
big-time!
I know this doesn't help much, but it's a problem with the ODBC drivers.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
> -----Original Message-----
> From: Gordon Burns [mailto:[EMAIL PROTECTED]]
> Sent: 19 May 2000 17:58
> To: [EMAIL PROTECTED]
> Subject: Excel Import
>
>
>
>
>
> 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.
------------------------------------------------------------------------------
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.
