Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Charlotte, NC
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •