newbie question

[Helen]

Hi,
I've been asked to build an access report that pulls from 3 Access
2007 databases. These are exported from SharePoint lists.

The schema for each list is the same - simple timesheet data: Employee
name, Manager, Department, Date, time in, time out, notes, etc.

Within each exported database there's a table called "Attendance".
This is a list of all the users' time.

I'd like to create a new database, called "Master Reports" or
something. This would have a table called "All Records" which would
agreggate all the data from the 3 exported databases.

I can then build reports on this master table.

Is this easy to do? Any pointers?

Thanks in advance.
Helen

 

[Mr. B]

Helen,

I would suggest that you create your new database file and then link to the
tables in each of the other three database files. Once you have created your
links, you will most likely want to rename the tables using some naming
convention that will let you quickly determine just which of the other three
databases each of the tables is from.

When you have your tables, you will be able to extract data from then using
queries.

HTH
Mr. B
askdoctoraccess dot com