Post reply

Updating a number of records

  • January 28, 2008 at 2:39 am

    #69549

    I have a csv file which contains a pc name and two dates (purchase date and warranty date) I need to update a SQL table where the pc name is identical to that on the csv file.

    How can this be achieved?

    I know it sounds a bit dim but I do this sort of thing so rarely that I don't want to miss an obvious point!!

    :Whistling:

    Madame Artois

  • January 28, 2008 at 3:42 am

    #772316

    Use OPENROWSET function together with INNER JOIN.

    N 56°04'39.16"
    E 12°55'05.25"

  • January 29, 2008 at 3:18 am

    #772779

    Thanks for that.

    :Whistling:

    Madame Artois

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

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