Like we both say, a pain. Here is another alternative:
It sounds like you can (slightly) change the format of the clients
spreadsheet "database". (If not create another sheet that will have this
following
column in it and link the client spreadsheet to that one)
If so, I would propose this:
Create a "hidden" column, that will not show to the client, but will
exist to the Excel ODBC connector.
format that column to be (related to the telephone col in question)
="T" & CellReferenceToColumnCausingProblems
This will force a text column and once you aquire the column in CF, strip
off the leading "T" (or whatever you choose to use) and start replacing
your hair...
Let me know if this helps...
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
>
--
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.
