Hi ExcelForum,

Basically, I'm trying to create a Reporting Tool that will generate a report from multiple Excel files (these Excel files are uploaded in a Sharepoint). I want to pull the data from these files then copy it into an MS Access Database file where the Reporting Tool will get the data for its report.

Here're my problems:
1. What do you think is better: Download first the files from Sharepoint then process the files or process the files directly from Sharepoint? How?
2. How do I create connection to MS Access using VBA? If you could give me a decent tutorial regarding this, it will be better.

Thanks.