View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Brown Frank Brown is offline
external usenet poster
 
Posts: 2
Default 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?