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?

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
>
>