> I have run into this before and it is really a pain to workaround. WHat
> happens is that excel has that column formated as a "general" column. I
> believe if the sheet had the column format as a "TEXT" format then this
> would help. Otherwise, the ODBC drivers look at the first row of data
> and ASSUME the rest of the column is that data type.
>
> So try and see if you can get the spreadsheet saved with that column
> listed as a text format. If you cannot do this then you will need to
> create an import spec that allows you to import the data in to an Access
> DB, then call Access from the cmd line (could use a CF_ tag for this)
> to imvoke a defined macro that will cause the import to take place.
> Doable, but a real pain.
>
> Steve
Tell me about being a pain! Actually the Excel ODBC looks at about the first
10-12 rows and decides... but as I've said on the other email, it's an Text
or Number situation, if it's text it ignores all numbers, and the same the
other way around.
The problem with getting Access to import the data is that it's a 3Mb file,
with (currently) over 7,500 rows, and continually growing - this is their
(effective) client database which needs to be updated on-line every day or
so (for their websites), so it's got to be as seamless as possible - and
with the speed of Access' import, it'd probably take a few minutes to import
that size of file, during which time, the client could run the on-line
"import new items" routine, which means that it wouldn't take all of the new
information.
I could run this, and tell them that after they have FTPed the file up, they
run the first stage import, leave it 30 minutes (to guarantee the Access
import) and then run the second stage - they are impatient enough already!
The more I use Micro$oft MDAC, the more I hate it's quirks.
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.
**********************************************************************
------------------------------------------------------------------------------
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.
