Automating the import of Excel data

[PaulA]

Greetings!

I am looking to automate the importing of Excel data to a specific table in as 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.

 

[ryan_kos]

I just got a form that will ask the user for the path of the file, and the name of the table to save it into. If this is what you want I can email you the form.

 

[Twin]

Hi Ryan,
could I kindly request the form please, it sounds interesting.

TIA

Chris

 

[Dina01]

Can I also have a copy

I was wondering if I can have a copy of thi form...


dinafederici@yahoo.com


Thanks