Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juvethski
Starting Member
46 Posts |
 Posted - 2005-11-01 : 14:57:49
|
| i'm just starting to learn stuffs about xml and sqlxml import. i tried to code some sripts but no success so far. i'd really appreciate if somebody here can show me how to import the xml doc (pasted below) and import it on sql. thanksthis is the sample xml document:<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Sync</Author><Company>Creo</Company></DocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowHeight>9210</WindowHeight><WindowWidth>15195</WindowWidth><WindowTopX>0</WindowTopX><WindowTopY>90</WindowTopY><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Bottom"/><Borders/><Font/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s23"><NumberFormat ss:Format="@"/></Style></Styles><Worksheet ss:Name="Campaign (201)"><Table ss:StyleID="s23"><Column ss:StyleID="s23" ss:AutoFitWidth="1" /><Column ss:StyleID="s23" ss:AutoFitWidth="1" /><Row><Cell><Data ss:Type="String">Id</Data></Cell><Cell><Data ss:Type="String">Name</Data></Cell></Row><Row><Cell><Data ss:Type="String">701300000000Kd4AAE</Data></Cell><Cell><Data ss:Type="String">XYAZ 2004</Data></Cell></Row><Row><Cell><Data ss:Type="String">701300000000KsoAAE</Data></Cell><Cell><Data ss:Type="String">Company Xyze CTP Complete - Phase 2</Data></Cell></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><Selected/><LeftColumnVisible>2</LeftColumnVisible><Panes><Pane><Number>3</Number><ActiveRow>1</ActiveRow><ActiveCol>1</ActiveCol></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>~~~~~~~~~~~~~~~~how's your data? |
|
|
|
|
|
an xml import scenario -- and question