In Microsoft Query, click the SQL button on the toolbar.ī.

Method 3: Add brackets ([) around the words 'Database' or 'Table.' ForĮxample, to select all records from a table called Database,Ī. Making the name a local one will cause the table name to beĭisplayed with the sheet name and then the range name: It as a local range name, such as 'Sheet1!Database.' Note that That contains a global range named 'Database' or 'Table,' define Method 2: If you are accessing data from a Microsoft Excel 5.0 workbook

Method 1: Name the range something other than 'Database' or 'Table.' These workarounds are not set within Impromptu but are for the Driver. Please contact Microsoft for further information on this technique. Microsoft offers the following as a workaround. Tables thus to eliminate the problem the attach must be made using the The problem is due to the driver not supporting quoted schema's This option is also set in the Options for the ODBC driver. It may also be necessary to change the delimiter type in the ODBC drivers options, and to use Escape Metacharacters when retrieving the data. Please contact Microsoft for further information on this issue.Īs a workaround it may be possible to Qualify the Tables Less in the Catalog Tables dialog window. Microsoft have documented this issue in their Knowledge Base articles #Q124322, Q125959 and Q124319. This error is due to an issue with the ODBC driver. When querying an ODBC datasource using the Microsoft ODBC Text Driver. DMS-E-GENERAL, A General Exception has occurred during operation 'prepare request'.ĭMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.

Microsoft notes