Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: copying records between databases

    hi, I have two databases (the existing one with bad design flaws, and the new one I've written) and I need to copy over some records from the old one to the new. For the most part, the design of the few tables in question has thankfully not changed much (except for the names of some of the columns), and I was wondering if there's an easier way to transfer the data over short of typing each entry in individually
    Is there any easy way? And while I'm at it, is there any way to copy the data over where the design HAS changed? eg, taking a table with 5 columns, and telling it to copy Columns 1-2 to table A, columns 3-4 to table 2, and Columnn 5 (now the linking field) to both

  2. #2
    Join Date
    Jul 2004
    Southampton, UK
    There are many ways...

    If you haven't got too many records then copy an paste will do.

    A more technical way is to create a link in your new db to the table in your old db. Then you can use APPEND queries to copy the relevant columns from the old table into the new tables. The column types must be the same. This is probably the better route because it's more robust. If you spot a mistake in your copying logic you can just change the queries and redo but with copying and pasting you have little record of what you've done or if you are going to do it right again e.g. when copying you accidentally miss the last 100 rows.

    Another way which might suit is to copy the entire table across (import) and simply rename and delete the columns you don't want. Then copy again for each of the other tables.


Posting Permissions

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