Leveraging XP Excel , XML, and OPENXML for Data Imports

Question

Leveraging XP Excel , XML, and OPENXML for Data Imports

sholliday

SSCrazy

Points: 2100
More actions
October 25, 2005 at 3:46 pm

#169560

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

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

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

Merrill Aldrich SSCrazy Points: 2358 More actions · Answer 1

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 More actions · Answer 2

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