How to edit existing MS Query in Microsoft Excel 2007

[connoisseur]

This is an EXCEL 2007 / MS Query question. When I have queried another sheet in the same excel file, and I want to edit that query sometime later, I get an error window "ODBC Excel Driver Login Failed" and after that I also get "Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt." What can I do to fix this issue. It seems to refresh fine, but I cannot get into the query to make any changes I want.

[Gania]

Using VBA in Excel allows us to perform many tasks automated, both formats and data itself. The "traditional" way is to travel to work data lines, work cells and ranges, and so on. To connect the data you need to pass the Driver, with the Excel ( {Microsoft Excel Driver (*.xls)} ) that is specified and the name of the book route. You can specify the provider, although not essential, for receiving the data driver assuming that the object and the provider is Microsoft OLE DB Provider for ODBC Drivers. Another fact that must be passed is the ID of driver, that is DriverID, whose value is Accessing Data with ADO.