Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    21

    Unanswered: import data from excel to MS SQL using DTS

    Hi guys,
    I need to import data from excel to MS SQL table, but I already have data in MS SQL table, I just want to update one column.
    How can I do that?
    wuadko

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are a zillion (or is that a squintillion Rudy?) ways to do this, but I'd suggest bringing the Excel worksheet into a scratch table, then doing an update of the column in the target table, with lots of error checking added for good measure.

    -PatP

Posting Permissions

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