陈锋-TechBlog

 1, OleDB, look in to the code sample following:public static String ReadIn ( string sheetName )...{    StringBuilder output = new StringBuilder( 512, 4096 );    StringWriter writer = new StringWr

This sample illustrates how to read XML from a file using the XmlTextReader class. This class provides direct parsing and tokenizing of XML, and implements the W3C Extensible Markup Language (XML) 1.0

First, you can read data  Excel Data into a Dataset: Code: Reading Excel Data into a Dataset (Visual Basic)   Then you can create the table in SQL server using the DataSet. Sample here: HOW TO: Im

 Steps for Configuration Manager: Make Browser service automatic from Manual in SQL Server 2005 services Go to Network Configuration in Configuration Manager Enable TCP/IP Enable Named Pipes