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