Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Question Unanswered: combine multiply mdb file into one?

    i have multiply mdb file (100+) with the same table name and field names. the only thing different is the name of the .mdb file. i know how to combine by going to external data, access, but that only allows one mdb at a time. how would i go and combine all these together with out manually doing one at a time?

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Is there any logic to the fieldnames of these databases? If there is you might be able to loop through them and import as you go.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2009
    the fieldnames are last, first, dob, and filepath for all of the mdb file.

Posting Permissions

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