vaughan198
Registered User.
- Local time
- Today, 03:44
- Joined
- Nov 16, 2011
- Messages
- 40
Hi there. I know that this has been discussed a lot but I can't seem to find quite the right solution to my problem.
I have an excel file that is emailed to me every day with three sheets/tabs in it.
I wish to add these excel records to the bottom of three different tables in my database. The excel file has headers which are the same as the ones in my database.
The filename also changes each day so it would either need to import the most recent file or (better in case there are newer files-like over the weekend) I would be able to select the file.
Any help would be hugely appreciated.
Thanks,
Will
I have an excel file that is emailed to me every day with three sheets/tabs in it.
I wish to add these excel records to the bottom of three different tables in my database. The excel file has headers which are the same as the ones in my database.
The filename also changes each day so it would either need to import the most recent file or (better in case there are newer files-like over the weekend) I would be able to select the file.
Any help would be hugely appreciated.
Thanks,
Will