如何从Excel文件中提取数据，并插入到数据库

{A3的}

{A4纸}]

|潘迪亚阿尼尔:您可以使用OLEDB提供程序从Excel中读取数据。下面是示例代码。codeprelang="c#"spanclass="code-keyword"using/spanSystem.Data;spanclass="code-keyword"using/spanSystem.Data.OleDb;...OleDbConnectioncon=spanclass="code-keyword"new/spanOleDbConnection(spanclass="code-string"@"/spanspanclass="code-string"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Book1.xls;ExtendedProperties=Excel8.0"/span);OleDbDataAdapterda=spanclass="code-keyword"new/spanOleDbDataAdapter(spanclass="code-string""/spanspanclass="code-string"select*fromMyObject"/span,con);DataTabledt=spanclass="code-keyword"new/spanDataTable();da.Fill(dt);spanclass="code-comment"///spanspanclass="code-comment"Ithinkyouknows..howtoinsertdatafromDataTabletoDtaBase./span/pre/code标记为答案，如果可以帮助......它促使imgsrc=http://www.orcode.com/img/ico/smiley_smile.gif
RaviRanjankr:尝试
{A5的}]