Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Unanswered: Moving Records from One database to another.... Newbie help!

    Hello all,

    I am very new to MS Access, but understand the basics (tables, fields, forms and queries) but I have come across a situation that I am not sure how to solve...

    I have 2 databases, both are identical and each contain 5 tables. One is a "live" database, with information being written to it regularly. The other db is for archival purposes. So when a set of records in the "live" db become obsolete, I want to be able to move them into their respective tables in the archival db.

    My current method...

    1. isolate the records to move by using a filter
    2. export the records to excel
    3. import the excel into the archive db
    4. delete the records in the 1st db

    I cannot believe that this is the only way of doing it! There must be a more efficient way than this!

    Does anyone have a proposed solution? can I "connect" 2 databases and move records, or perhaps a macro might do it? I am open to any suggestions!

    Thanks very much for your time!

    M.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    1. Move the data to the archive database directly, using criteria.
    2. Delete the data in the live database.

    Why on earth are you using Excel to do this
    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

  4. #4
    Join Date
    Aug 2009
    Posts
    2
    hey there,

    what exactly do you mean by criteria, sorry about this, kinda new to access! Been using excel simply because I found the export facility and made the best of a bad situation!

  5. #5
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Criteria (for instance) = Records that are older than etc.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Filters contain criteria to restrict records for example... like anything in the criteria row of a query.
    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

Posting Permissions

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