Hello,
We have a large database with camel case names for schemas, tables, columns, etc. I'm able to connect via ODBC with MS
Access,but not with Excel (MSQuery). The names are not quoted and lowercase folding kicks in - so all tables are 'not
found'. If I manually edit the MSQuery sql and double-quote all names, i can get the queries to work - but each and
everyquery must be manually edited. Obviously unworkable.
Is it possible for the odbc driver to return schema, table and column names to MSQuery in double-quoted form so queries
arebuilt correctly? Alternatively, could the odbc driver insert double-quotes on-the-fly once it sees uppercase
charactersin the names?
This would help us immensely!!!
Thanks in advance,
Tom Agnew
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp