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