Leveraging XP Excel , XML, and OPENXML for Data Imports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Sloan Holliday » Leveraging XP Excel , XML, and OPENXML for...

Leveraging XP Excel , XML, and OPENXML for Data Imports

Rate Topic

Display Mode

Topic Options

Author

Message

sholliday

Posted Tuesday, October 25, 2005 3:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 8:53 AM
Points: 113, Visits: 146

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

Post #232216

Merrill Aldrich

Posted Tuesday, November 22, 2005 9:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 14, 2013 2:07 AM
Points: 126, Visits: 123

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.

Post #238922

katesl

Posted Thursday, November 24, 2005 4:19 PM

Valued Member

Group: General Forum Members
Last Login: Saturday, April 27, 2013 5:57 PM
Points: 60, Visits: 405

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.."

Post #239553

« Prev Topic | Next Topic »

Permissions