If you import data to SqlServer in Excel, the system prompts: too many fields are defined? Source code: fileName file name savePath path DataSetdsnull; try {stringmyStringProviderMicrosoft. Jet. OLEDB.4.0; DataSource + savePath + fileName +; ExtendedPropertiesExcel
If you import data to SqlServer in Excel, the system prompts: too many fields are defined? Source code: // fileName file name // savePath path DataSet ds = null; try {string myString = "Provider = Microsoft. jet. OLEDB.4.0; Data Source = "+ savePath + fileName +"; Extended Properties = 'excel
If you import data to SqlServer in Excel, the system prompts: too many fields are defined?
Source code:
// FileName file name
// SavePath path
DataSet ds = null;
Try
{
String myString = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" + savePath + fileName + "; Extended Properties = 'excel 8.0; HDR = No; IMEX = 1 '";
OleDbConnection oconn = new OleDbConnection (myString );
Oconn. Open ();
Ds = new DataSet ();
OleDbDataAdapter oda = new OleDbDataAdapter ("select * from [Sheet1 $]", oconn );
Oda. Fill (ds );
Oconn. Close ();
}
Catch (Exception ea)
{
My. ClientScript. Alert (this, "error of the provided document:" + ea. Message );
}
Return ds;
Solving?