Post reply

Copying data between tables

  • April 17, 2015 at 1:36 am

    #1791583

    Ah, didn't know that (don't usually work with Identity columns).

    For my solution, I ended up cheating.

    I scripted all the columns I needed from the tables, put them into Excel and wrote a bit of VBA to create the INSERT INTO and SELECT statements.

    For future reference, is there a better way of doing this?

  • April 17, 2015 at 1:39 am

    #1791586

    richardmgreen1 (4/17/2015)

    For future reference, is there a better way of doing this?

    Cough... BCP 🙂

    -- Gianluca Sartori

Viewing 2 posts - 16 through 16 (of 16 total)

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