Post reply

Insert a text file data into a existing table with increment PK by one

  • November 11, 2005 at 2:26 am

    #89894

    Hi,

    I have a text file data. I want to insert the textfile into an existing table that has increment PK by one. The data file does not contain increment numbers. How can i do it via SQL enterprise manager?

    Thanks in advance

     

    - Loi -

  • November 11, 2005 at 8:14 am

    #603439

    You can either use the DTS export/import wizard and map the correct fields so that the autoincrement column takes place correctly or use bcp/bulk insert commands to do the loading (use a format file).

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

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