Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    1

    Question Unanswered: Merging multiple DBs

    I need to merge serveral Access DBs (all located in the same folder) with the same structure into one master database. I need to automate this as part of a script or batch job.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps have one master database that links to all the others and does append queries.

    File | Get External Data | Link Tables...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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