Queries to import data from Access

R

R Ormerod

If I change the drive location of an Access database from which I am
importing data into an Excel workbook (I set the query up using the Microsoft
Query wizard), I get the following error message:

"ODBC Microsoft Access Driver login failed: Could not find file
'xxxx\xxxx\xxxx.mdb'"

Is there any way to get round this without having to delete my queries and
reimport them from the database in the new location?

FYI - I use Excel & Access 2000.
 
F

Frank Stone

hi,
yes there is. you will have to change the file path in the
MSQ. to do that, bring the query up in design mode. on
the tool bar, click View>SQL. change the file path and
you're in business.
regards
Frank
 
R

R Ormerod

I cannot get into Edit Query if the Access database has already been moved to
a new location - I get kicked out with the same error messages as before.

Is there a generic way to get into Microsoft Query?

Frank Stone said:
hi,
yes there is. you will have to change the file path in the
MSQ. to do that, bring the query up in design mode. on
the tool bar, click View>SQL. change the file path and
you're in business.
regards
Frank
Click to expand...
 
Top