Hi Tom,
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.
Cheers,
Eric
agnewtj@netscape.net wrote:
>Hello,
>
>We have a large database with camel case names for schemas, tables, columns, etc. I'm able to connect via ODBC with
MSAccess, but not with Excel (MSQuery). The names are not quoted and lowercase folding kicks in - so all tables are
'notfound'. If I manually edit the MSQuery sql and double-quote all names, i can get the queries to work - but each
andevery 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
queriesare built correctly? Alternatively, could the odbc driver insert double-quotes on-the-fly once it sees
uppercasecharacters in 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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>
>