Finding source of linkied Database??
 

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?


--
mattylance
------------------------------------------------------------------------
mattylance's Profile: http://www.excelforum.com/member.php...o&userid=35070
View this thread: http://www.excelforum.com/showthread...hreadid=555369

Finding source of linkied Database??
 

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.

"mattylance" wrote:


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?


--
mattylance
------------------------------------------------------------------------
mattylance's Profile: http://www.excelforum.com/member.php...o&userid=35070
View this thread: http://www.excelforum.com/showthread...hreadid=555369