Help...create a report that pulls from multiple tables

K

kozamel

I am a VERY new Access user...

I have 15+ tables, each with identical field names (linked sprdshts from
Excel), and each containing schedule information for a specific project.

I am trying to create an interface that would allow each project manager to
update their spreadsheet...and utilizing access to create different reports.
However...I can't seem to figure out how to do that...

I have Office 2003 - but the database I have open says it is in 2000 format.

Can the program even do what I need?
 
D

Duane Hookom

What exactly do you want to do in Access. You won't be able to update the
Excel data if you have the latest service packs applied. If you want to
create a report of multiple linked worksheets, you might be able to create a
union query and use that as the basis for your reports.
 
Top