Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Leveraging XP Excel , XML, and OPENXML for Data Imports Expand / Collapse
Author
Message
Posted Tuesday, October 25, 2005 3:46 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 4, 2014 7:31 AM
Points: 117, Visits: 176
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sholliday/leveragingxpexcelxmlandopenxmlfordataimports.asp


Post #232216
Posted Tuesday, November 22, 2005 9:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 3:27 PM
Points: 126, Visits: 137
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
Posted Thursday, November 24, 2005 4:19 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 16, 2014 7:20 PM
Points: 63, Visits: 470
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 »

Add to briefcase

Permissions Expand / Collapse