Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query does not quote identifiers in the generated SQL
Out users need to analyze data in a Postgres database. The Schema, table,
and field names are all in UPPER case. After selecting the particular datasource, MS Query Wizard correctly presents the tables, and upon choosing a table correctly displays all the fields. After choosing the desired fields, and then executing the query, a tombstone appears saying 'Error: Schema "scott" does not exist'. This is true because the name is "SCOTT" not "scott". If I manually type the SQL, and include the appropriate quotes, the select works fine. I have tested this with both Excel 2002 and Excel 2007 with the same result. Is there a way to cause the MS Query Wizard to fill in the appropriate quotes? Is there another workaround? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stock quote lookup query for Excel 2000 | Excel Worksheet Functions | |||
Unable to open MSN stock quote query in get external data in Exce | Excel Programming | |||
An MD5 Hash with a single quote = grief in SQL query | Excel Programming | |||
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! | Excel Programming | |||
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming |