Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Hyderabad
    Posts
    16

    Unanswered: Data Transfer Between MDB

    How transfer data present in one MDB to another MDB when both the MDB are of same design
    pradeeep

  2. #2
    Join Date
    Jan 2002
    Posts
    10

    Here's how

    These are the two methods I prefer:

    (1) Link the tables from one database to another, and do a standard INSERT query, or
    (2) Use the IN clause in your SQL Statement, e.g.:

    INSERT INTO [MyTable] In "C:\MyData\MyDB.MDB"
    SELECT * From MyTable
    Brendt

    We are the music makers, and We are the dreamers of dreams...

Posting Permissions

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