ExcelBanter - Error Editing an MS Query in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Error Editing an MS Query in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/230434-error-editing-ms-query-excel.html)

ChrisG

Error Editing an MS Query in Excel

I get an error when opening an MS Query in Excel "Query cannot be edited by
Query Wizard". If you click O.K all you can do is view and edit the SQL
Statement.
History:
Upgraded from MS Office 97 to MS Office 2007. Data source is AN IBM AS/400
using DB2 and OBDC Driver is the IBM Supplied Client Access OBDC Driver.

Any suggestions?
Thanks
Chris

joel

Error Editing an MS Query in Excel

Ignore the error message. Can you still do what you need to do?

"Chrisg" wrote:

I get an error when opening an MS Query in Excel "Query cannot be edited by
Query Wizard". If you click O.K all you can do is view and edit the SQL
Statement.
History:
Upgraded from MS Office 97 to MS Office 2007. Data source is AN IBM AS/400
using DB2 and OBDC Driver is the IBM Supplied Client Access OBDC Driver.

Any suggestions?
Thanks
Chris

All times are GMT +1. The time now is 09:47 PM.