c# - Problems Reading a .xlsx file? -


I have created a test file, and runs right through the excel file, but NII has a lot of data Enter, I get the following error: 

  Microsoft Office Access Database Engine Object 'Sheet1 $'

Do not think that is incredibly obvious, But 'Sheet1' is definitely there, just in my test file - I have checked about 30 times on the first sheet. It is only data and it is clearly given as the name 'Sheet 1' by default. Any ideas why I still get this error?

code: 

  string path = server.mappath ("~") + "\\ attachment \\ ejmaps \ ejmaps.xlsx"; String connString = string.format ("provider = Microsoft.ACE.OLEDB.12.0; data source =" + path + "; extended property = \" excel 12.0 xml; hdr = yes \ ";); OleDbDataAdapter adapter = New OleDbDataAdapter ("SELECT * FROM [Sheet1 $]", conic string);

Strange ... I originally changed his name (EJMaps Pull .xlsx) And did this work?

Why would anyone have any idea?


Comments

Post a Comment