Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var fileName = string.Format("C:\Drafts\Excel 97-2003 formats\All Data 09 26 2012_Edited.xls");
- var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName);
- var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
- DataSet Originalds = new DataSet();
- adapter.Fill(Originalds, "Employees"); // this is where the error shows up
Add Comment
Please, Sign In to add comment