-
Import range of cells from Excel to Access
I have a database that I am working on and want to import a range of cells from excel. The user will be receiving a daily, monthly, and quarterly excel file in a zipped format. I already got a good starter solution from westconn1 (ThankYou!!!) on how to automatically download, unzip, and save the file. One thing that was suggested to me was to link another excel file to the one with the information and then use that file as the import. I would just need to make sure that the source files name always stays the same. Does anyone have any good solutions for this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules