Realization of Data Transmission Between Excel and SQL Server by C

The connection and the data transmission between Excel and SQL server is studied by Visual Studio2005.The Excel software has great advantage in amending,editting the date,and userfriendly printout,while SQL server can execute better than Excel in terms of inquiring and the security aspects of the data.Therefore,data transmission between Excel and the SQL server realized by C# can meet the needs of different users.