Hi
I am trying to import an excel spreadsheet using the following:
string theFileName = this.txtUploadedFile.Text;
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + theFileName +
";Extended Properties=Excel 8.0;";
//You must use the $ after the object you reference in
the spreadsheet
OleDbDataAdapter myCommand = new
OleDbDataAdapter("SELECT * FROM [" + wSheet + "]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
It seems to be working OK, but it is randomly omitting field
values.i.e. My input spreadsheet has values
1, CT, 10/01/2008, YES
The imported array has
,CT,,YES
Why is it randomly ignoring some data?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
