Two Origins, One Destination Excel Imports

J

Judi

I have to figure out how to import data from 2 different Excel files which do
not hold the same information accross the board, but do hold the information
that I need to create some reports. I need to import them into the same place
and then extrapolate the information I need to create these reports.

I am relatively new to Access and would like to know if this line of
approach would work. Or, if anyone has a better idea, please let me know.

I'm thinking that I need to:
1) import each file into a new access table
2) create a new table that I can import both sets of info into
3) create an update query to bring both sets of information into the same
table
4) create a query for a report on this information
5) create the report

I feel like this is all very roundabout and I'm a little ticked that 2
people in my department can't make the transition to use the same database as
the rest of them, but that is not my call, and yet I need to make these 2 fit
in with the rest when I create reports.

Please help me, and if the only way to do this is to usa VBA, please talk
slowly and with as little accent as possible because I'm new and slow.

Thank you!
 
K

Klatuu

You can shortcut the process a bit.
Link to both Excel files as tables and use a query based on those tables as
the record source for your report.
 
J

Judi

This sounds good, can I also use data from inside the database too?

What I'm doing is gathering monthly information from 3 sources, the
database, and 2 excel spreadsheets. Then, I need to gather data from those
sources to find out the number of quotes, the amount in dollars quoted, the
amount in weight (of steel) quoted and the percentage of ontime quotes for
each estimator.

Can I put all of this information on the same report?
 
Top