Re: create an acess report from multiple exel files

Kim

I can't be sure from your description, but it sounds like the "folders" and
Excel files have different names.

You could use an Access .mdb file to "link" to each of those, but if the
names change, you'd have to "link" to the new files/folders each time (this
might be automated, but it is a not-insignificant programming effort).

If you have an Access .mdb file with links to each/all the spreadsheets, you
might consider using UNION queries to pile all the data together (since each
month's data is apparently in a different place).

You could consider using automation from within Access to "gather together"
the data from all those Excel files, placing it in a well-normalized table
structure (individual monthly Excel files is not a well-normalized
structure).

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"p16458" <p16458@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DDE6076A-2128-4879-AEB9-56311EA1C859@xxxxxxxxxxxxxxxx
Hello guys,

I have billing statements that are all done in exel with a template and
stored in folders by month order.
At the end of the month, I need to make a report giving: name, account
number, payment due. This information is stored in the same cell in each
bill
as a template is used.
I am doing it manually by opening each individual exel file and copy
information and paste to another spread*** to create my report.

Is it possible to extract some data from multiple exel files and create a
report?
Does anyone have any idea how to work around this? I really appreciate
your
time and help.

Kim


.