Day to day good stuff I find regarding my work

Wednesday, April 12, 2006

Move Excel to SQLserver

Introduction to Excel Services,

Start look at

Office 2003 XML Reference Schemas
http://www.microsoft.com/office/xml/default.mspx

How to import data from Excel to SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;321686

Loading and reading the Microsoft Excel file contents using C#
http://www.codeproject.com/useritems/Excel_Application_in_C_.asp

Convert Excel to XML file/XML Schema, and validate Excel against XML Schema
http://www.codeproject.com/csharp/excel2xml.asp

Using the Excel 2003 XML Tools Add-in Version 1.1
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/OfficeExcelXMLToolAddin.asp

Office 2003: XML Reference Schemas
http://www.microsoft.com/downloads/details.aspx?FamilyId=FE118952-3547-420A-A412-00A2662442D9&displaylang=en


SQL DTS
http://www.sqldts.com/

No comments: