Leveraging XP Excel , XML, and OPENXML for Data Imports

  • sholliday

    SSCrazy

    Points: 2099

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sholliday/leveragingxpexcelxmlandopenxmlfordataimports.asp

  • Merrill Aldrich

    SSCrazy

    Points: 2142

    Also, look at OPENROWSET, which can directly access an Excel worksheet with SQL statements, as if it were a table. No need for the step exporting to XML, no need to put the document in a text variable.

  • katesl

    SSCommitted

    Points: 1743

    Excel is a source for DTS.  No need for openrowset either.  Just edit the worksheet to make (only) row A the column headers, point to the file after choosing the Excel source in DTS, and DTS creates one table per worksheet.

    _________________
    "Look, those sheep have been shorn."
    data analyst replies, "On the sides that we can see.."

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

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