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

Mtaylorlc · Apr 2nd, 2002, 01:41 PM

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!

Tom Schreiner · Apr 2nd, 2002, 02:05 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 01:41 PM	#1
Mtaylorlc New Member Join Date: Mar 2002 Location: Charlotte, NC Posts: 40	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!

Apr 2nd, 2002, 02:05 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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