Changing Data Source

N

nathan_savidge

Hi,

I have taken over a task to modify a report, in Excel, using access data.
However i can't change the database that the excel queries point to. I did
it by QueryTable.Connection, but it doesnt change the SQL in MS Query.

When i edit the query, i go to the next stage after where you normally
select the database.

Can anyone help?

Thanks

nathan
 

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

changing query source 2
Should I save a new query for each report or use the same and modi 1
Can't change Pivot Table data source 2
Editing Queries In Excel 2007 1
excel 2007 right click edit query 1
Counting multiple memberships 1
Access Access Queries 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top