While uploading Excel files to DB server some files cannot be uploaded开发者_JAVA百科. This error was caused while getting the column names of that excel file using the function:
dtExcel = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, Nothing)
Seems like problem with Excel OLEDB driver and/or connection string
Try these posts
- Diagnosing an OLEDB exception when Quering Excel 2010
- http://connectionstrings.com/excel-2007
精彩评论