Importing Excel files monthly when path changes
Posted on 2006-06-06
My deparment relies on exporting certain information from our database into an Excel file. This information is "randomly" incorrect, but we were able to manage it because we only had a few rows to check on a monthly basis. The rules are changing, and we are going to need to start exporting historical information starting in the begining of July, which will push these Excel files up to the tune of hundreds of rows of data to check.
Since we can not rely on our current database to provide us consistant correct historical information on a month-by-month basis, I would like to set up an access database that will import those Excel files (both prior and current month) and compare the tables for variances.
I can handle the queries, but my problem is that the "prior and current month" excel files change location each month. Ideally, I would like for the analysts to open the database and click a button that says "import files" and have the program prompt them to locate both the prior and current month's files manually.