Macro to open .xls files in a folder and update database

[Mtaylorlc]

I'm using the template wizard with data tracking, I need to create a macro that will loop to open all of the .xls files within a folder, save each, and create a new record or update an existing record...

I have a checklist that will be completed by 100 +/- individuals and e-mailed back. I intend to dump them into this folder and run the macro from within a separate workbook to populate my database.

Could someone suggest a macro the would open each .xls file, save, and create/update a record? If create or update causes a problem. I could use one that just created a new record... I could clear the database before running. Any thoughts? Thanks!

 

[Legacy 98055]

Hi
What database?
Access?
Names of tables?
Names of fields in each table?
Data arrangment on individual worksheets?
....10 more questions...
Big question with so little info.
E-Mail TsTom@hotmail.com if you are unable to get the help you need.
I need some database practice.
Tom