Greetings!
I am looking to automate the importing of Excel data to a specific table in an Access database.
The issues:
1. The data would be submitted by multiple persons (probably to a shared drive) in files with multiple file names on a monthly basis.
2. The persons submitting could vary from month to month (new hires and terminations)
I am familiar with the "Transfer Spreadsheet" function which could be used multiple times for each pre-designated file name--but I was wondering of any way to have more flexibility in the automation.
Any suggestions, or other help would be much appreciated!
Thanks.
I am looking to automate the importing of Excel data to a specific table in an Access database.
The issues:
1. The data would be submitted by multiple persons (probably to a shared drive) in files with multiple file names on a monthly basis.
2. The persons submitting could vary from month to month (new hires and terminations)
I am familiar with the "Transfer Spreadsheet" function which could be used multiple times for each pre-designated file name--but I was wondering of any way to have more flexibility in the automation.
Any suggestions, or other help would be much appreciated!
Thanks.