excel 导入SQL
摘要:一、在程序中,用 ADO.NET。代码如下: //连接串 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + [EXCEL文件,含路径] + ";"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataTable dtSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Table
阅读全文
posted @ 2011-08-24 09:35
浙公网安备 33010602011771号