Excel unable to importa data from "mdb" file link

S

SFX

My excel uses database query from mdb (MS access) file. Now the file location
has changed.

So I am not able to "Refresh Data", inspite of creating a mdb shortcut to
correct folder.

For some reasons I can't copy the mdb file to new location, so looking for
workaround.

Is there any way to edit queries... (i am not able to do since it doesn't
recognize mdb file in first place)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
cannot refresh linked access table if source database is locked 0
erratic response while working on a table in excel linked to a tab 0
Linking Backend MDB Tables Programmatically 2
Excel 2007 Query Wizard problem with Access 2007 extensions 0
erratic response while working on a table in excel linked to a tab 2
Can Linux extract data from .MDB file, and output to text ? 1
Combine 10 mdb files with different fields but common emp codes 3

Top