(C #) Excel data import into SQL Server

excel|server|sqlserver| Data Writing program, put the appendix of the Excel file (experimental questions Annex 1) class 03 student list. xls
or (appendix 2 of the Experiment) the performance registration form. xls) is imported into the SQL SERVER2000 database.
Requirements:
1. Excel file as data source
2, according to the Excel file fields in SQL Server to establish the corresponding fields
3, the record in the execl to the SQL Server


String Strcon = "Provider = microsoft.jet.oledb.4.0;" Data Source = C:\\test.xls; Extended Properties=excel 8.0 ";
OleDbConnection myconn = new OleDbConnection (Strcon);
MyConn.Open ();
String strcom = "Select Category,comp_num from [sheet1$]";
OleDbDataAdapter mycommand = new OleDbDataAdapter (strcom,myconn);
DataSet1 = new DataSet ();
Mycommand.fill (DataSet1, "[sheet1$]");
Myconn.close ();