Results 1 to 9 of 9

Thread: How do you move or copy data into another database?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253

    Question

    Hi

    I'm trying to move data from one database table to another database table. What I did was rebuild the old database to update some fields and now I would like to move the data into the database I rebuilt. Does anyone have any ideas?

    Thanks aja

  2. #2
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    What type of Database are you using? If you are using SQL server you can use DTS to move your data. If it is an Access DB use the import/export data option. If you have any questions post your DB info along with it and I'll give you a more descriptive answer.
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253
    I'm using ms access db. How exactly do you use the import/export method?

    thanks aja

  4. #4
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    OK, for an access db you will need to export to a text file unless you want the definition (Column Names & Properties) to be exported also.

    To do this:

    1. Right click on the table that contains your data.
    2. Click Save As/Export.
    3. Select External File.
    4. Change type to text file then click export. This will open up a wizard.
    5. Here choose delimited and click next.
    6. Select the delimiter you wish to use. You can set the "Text Qualifier" to none also.
    7. Now click next and then Finish.
    8. Now open the destination DB.
    9. Click get external data in the file menu.
    10.Click Import.
    11.Change type to text file and click import.
    12.Select delimited, then click next. Make sure you select the same delimiter here and set "Text Qualifier" to none. 13.Click next, now select your destination table. Click next and then Finish.

    This should help you get your data moved. Good luck.
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253
    I can get up to instruction number 3, then when I change the type to text and click export the wizard does not come up on the screen. Why is that?

    aja

  6. #6
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    I'm not sure what would cause that. I just went through the process to make sure it was correct. Make sure you have a file name entered and also make sure "Save Formatted" isn't checked. Providing the above is done this should work fine for you.
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA

  7. #7

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Fremont Ohio 43420
    Posts
    253
    do you know the name of the wizard so I could do a search to see if I even have installed it?

    thanks aja

  8. #8
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    Export Text Wizard
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA

  9. #9
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008

    Lightbulb Moving Data

    Joined this a bit late - there is a much easier way to do this.

    Create a Make Table query and define the target table as the same table name but in a different database. Select 'Another Database' option in the dialog box asking for the target table name, and type in the target .mdb full filename (with path and .mdb extension).

    Do a SELECT * and hey, presto! Table is copied over.

    i.e. If you are trying to move table Test in MyDb.mdb
    Code:
    SELECT Test.* INTO Test IN 'C:\MyPath\MyOtherDb.mdb'
    FROM Test;
    Cheers,

    Paul.
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

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



Click Here to Expand Forum to Full Width