Guest User

Untitled

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