What happens if you open the file in Excel, select the column, then
format it as text (as it really should be defined)...
I haven't tried this but I expect that that Excel and the driver
should handle it properly
HTH
Dick
At 6:18 PM +0100 4/28/2000, Philip Arnold - ASP wrote:
>It's been a long time since I've been on this list, but I've run into a
>problem that someone here might have some insight into...
>
>I'm using an Excel ODBC datasource (as that's how the client supplies 3Mb of
>data), but the same problem arises if I make it as a Link Table in Access,
>or even as a CSV datasource
>
>Two of the columns are telephone numbers, but when ODBC reads it, it treats
>it as a numeric, which means that any entries which have spaces in are
>ignored - as they aren't truly numeric, e.g. 0015124267712001 works (as
>15124267712), but 001 512 426 7712 is ignored.
>
>I know it's something in the Excel connector, but I'm hoping I can solve
>this.
>
>I'm running MDAC 2.1 SP2 (is 2.5 worth the upgrade?) and CF 4.01 (I know I
>should run my upgrade to 4.51, but I haven't had the chance yet)
>
>I hope someone can help me with this, as I'm tearing my hair out (what
>little I have left)
>
>TIA
>
>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_tal
>k 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.
