Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Sloan Holliday Leveraging XP Excel , XML, and OPENXML for Data Imports RE: Leveraging XP Excel , XML, and OPENXML for Data Imports
Merrill Aldrich
SSCrazy
Points: 2358
More actions
November 22, 2005 at 9:58 am
#605280
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.