Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting error:External table is not in the expected format.while u
hi,
i am using microsoft jet engine to process an excel file and then uploading it to the server but i am getting the following error whent the application tries to open the connection: " "External table is not in the expected format" the code for this is mentioned below: Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + postedfile + ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" Dim conn As OleDbConnection conn = New OleDbConnection(strConn) conn.Open() '--------------------------here i am getting exception dtSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing) If dtSchema.Rows.Count 0 Then strSQl = String.Format("SELECT * FROM [{0}$]", dtSchema.Rows(0)("TABLE_NAME").ToString.Replace("' ", "").Replace("$", "")) End If Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External table is not in the expected format. | Excel Discussion (Misc queries) | |||
External table is not in the expected format. OWC11 | Excel Programming | |||
External table is not in the expected format. OWC11 | Excel Programming | |||
External table is not in the expected format | Excel Programming | |||
ADO - Excel - External table is not in the expected format | Excel Programming |