Whoa!?! Help!?! Complicated!?!

[ryan33]

Situation: I am using an Access db as the source of information for a pivot table. Currently the db is on an external drive, but I would like to move it to a local drive so I made a copy of the db. Going through the Pivot Table Wizard, I wanted to change where my pivot table looks to access the db. Once in MS Query, I go through the SQL dialog button and change the file path. Once I go back into Excel/Pivot Table, it seems to refresh the data. When I actually remove the db from the external drive and refresh the pivot tables, I get the error message: 'Could not find file: '[External Drive]:\[filename].mdb.'' I noticed that when I do refresh the table with the db on the external drive and a copy on the local drive, it accesses both files.

Question: If I change the file path in the SQL dialog, is there another place I need to make the change?

Any help would be appreciated.

Thanks.

Confused at my Computer

 

[rcg82]

Hi, why not use ODBC instead? Path your new Access database on the ODBC MS Access Driver.

 

[ryan33]

Do you know of a good help/how to demo on going through the MS Access Driver to link Access tables/queries up to pivot tables within Excel?

Thanks,

Ryan

 

[arthurbr]

I love your thread title .Have a look at forum rules

 

[MrByte]

Arthurbr made a good point about checking out the forum rules. Also be aware this is a double post too. http://www.mrexcel.com/forum/showthread.php?t=315657

 

[ryan33]

The post title was actually an experiment. As you said I had already posted the same issue on a different post with a much more descriptive title but did not get the same response as I did with this post. More views and more responses. I suppose since the human condition compels us to look at car accidents with curiosity, more people felt compelled to read my question as well. I guess it is a case of the boy who cries wolf, one of these days I may be sorry when the wolf comes and eats my family. Sorry for the alarm. Thanks for the help.

Ryan