Post reply

How to append data in the existing table through Import and export data wizard

  • November 11, 2011 at 11:00 am

    #390843

    I have a table and every qurater I want to append data into the same table using 'Import and Export Data' wizard.

    Please help,

    Thanks

  • November 11, 2011 at 11:12 am

    #1406524

    So long as the data does not violate UQ indexes or PKs, you can use that wizard. Just don't select to have the table truncated first.

    And, it would be better to use a different process that you could automate. SSIS, TSQL, BCP etc.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 11, 2011 at 11:19 am

    #1406527

    SQLRNNR (11/11/2011)

    So long as the data does not violate UQ indexes or PKs, you can use that wizard. Just don't select to have the table truncated first.

    And, it would be better to use a different process that you could automate. SSIS, TSQL, BCP etc.

    Also partitioning (ALTER TABLE...SWITCH), if applicable.

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

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