Leveraging XP Excel , XML, and OPENXML for Data Imports

  • sholliday


    Points: 2099

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

  • Merrill Aldrich


    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


    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