SQLServerCentral / Discuss Content Posted by Sloan Holliday / Article Discussions / Article Discussions by Author / Leveraging XP Excel , XML, and OPENXML for Data Imports / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 02:15:27 GMT20RE: Leveraging XP Excel , XML, and OPENXML for Data Importshttp://www.sqlservercentral.com/Forums/Topic232216-256-1.aspxExcel 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.Thu, 24 Nov 2005 16:19:00 GMTkateslRE: Leveraging XP Excel , XML, and OPENXML for Data Importshttp://www.sqlservercentral.com/Forums/Topic232216-256-1.aspxAlso, 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.Tue, 22 Nov 2005 09:58:00 GMTMerrill AldrichLeveraging XP Excel , XML, and OPENXML for Data Importshttp://www.sqlservercentral.com/Forums/Topic232216-256-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/sholliday/leveragingxpexcelxmlandopenxmlfordataimports.asp">http://www.sqlservercentral.com/columnists/sholliday/leveragingxpexcelxmlandopenxmlfordataimports.asp</A>Tue, 25 Oct 2005 15:46:00 GMTsholliday