Post reply

Appending data to an existing table

  • February 9, 2009 at 8:42 am

    #94564

    Hi

    I have two tables with same column names. I want to append the data from one table into the other table. This data was exported to SQL server from an Access database. +- 4 million records.

    Please assist

  • February 9, 2009 at 8:53 am

    #940539

    Do you want to eliminate duplicates or do you just want to append all records from one table to the other?

    In the second case just do:

    INSERT INTO TABLE1

    SELECT * FROM TABLE2

    [font="Verdana"]Markus Bohse[/font]

  • February 9, 2009 at 9:16 am

    #940567

    Thanks for the solution

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply