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_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
