Excel如下,这页工作表名叫“线路” 数据库表如下 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.OleDb; using System.Configuration; using System.Data.SqlClient; namespace insertData { class FileSvr
一.直接代码 var fileResult = openFileDialog1.ShowDialog(); if (fileResult == System.Windows.Forms.DialogResult.OK) { var fileName = openFileDialog1.FileName; OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="