I encountered this problem as well, and I agree that it's rather a
nuisance. You've probably thought of this, but if you are just using a
limited set of tables in Excel (like for pivot tables), you might just
try wrapping them into a view with lowercase names - this is what I
did. It might also be worth dropping a line to Microsoft about this
problem, as they have evidently made this work in Access, and I believe
quoting for mixed case is part of SQL92.
All that said, I definitely second your suggestion.
>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 every query 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 are built correctly? Alternatively, could the odbc driver insert double-quotes on-the-fly once it sees uppercase characters in the names?
>This would help us immensely!!!
>Thanks in advance,
>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
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
In response to
pgsql-odbc by date
|Next:||From: Mie Kie||Date: 2005-07-28 12:10:28|
|Subject: odbc win.xp and mandrake 10|
|Previous:||From: Pailloncy Jean-Gerard||Date: 2005-07-27 16:46:51|
|Subject: iODBC & Mac OS|