Finding source of linkied Database??

  • Thread starter Thread starter mattylance
  • Start date Start date
M

mattylance

I am trying to improve some spreadsheets that were designed by a former
coworker. He uses Excel to link in information from a database and
then minipulates it through several worksheets to get a report in
Excel.

I would rather avoid Excel alltogether and just have a Access report do
the job. However the source Database is very large and has many
different tables and queries that have similar or repetitive column
names. Therefore when I am in excel and I view the database wizard it
will only show me the column name and not the table/query it is linked
to.

Any advice?
 
You can try this from the visual basic editor (Alt+F11). Open the inmediate
window (Ctrl+G) and type:
?activesheet.querytables(1).commandtext
It will show the SQL from the query in the current worksheet, and it should
include the original tables.

Hope this helps,
Miguel.
 

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

Trouble using Access as source for Pivot Table 0
Changing Database links? 3
Checking/amending the external source link to an Access table 1
Change source of linked database query 1
Excel 2003 case sensitive problems with New Database Query 1
Not all Access queries can be imported 1
Can't create a report from my query in Access 1
Q: Change pivot table source path? 1

Back
Top