| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Database Query
I have created a data table in a worksheet and named it data. Then I
created a separate worksheet, in the same workbook, and created a database query of the data table, by using DataImport External DataNew Database QueryExcel Files* and defining the database name by browsing to the same workbook. The query worked fine. However, when I moved the workbook (which included the data source) to a different folder and tried to refresh the database query, I got the following error message: [Microsoft] [ODBC Excel Driver] The Microsoft Jet database engine could not find the object data. Make sure the object exists and that you spell its name and the path name correctly. How do I rectify this problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query a database on a server not working | Excel Discussion (Misc queries) | |||
| MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
| Database Query -- Data Type Mismatch | Excel Discussion (Misc queries) | |||
| Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
