> TRY > SELECT (m.tvWorkarea) > > **** New Code Start **** > *JAL* Excel ODBC driver has a bug that assumes first row always contains column names > *JAL* See http://support.microsoft.com/kb/288343 > *JAL* If first row contains data, you have to use OLEDB driver and ADO to read data > If m.lcHeaderRow = "No" > Local loConn as ADODB.Connection, loRS as ADODB.Recordset, loCursor as CursorAdapter > > loConn = CreateObject("ADODB.Connection") > loConn.ConnectionString = [Provider=Microsoft.ACE.OLEDB.12.0;Data Source="] + m.tcXLSFile + [";Extended Properties="Excel 12.0;HDR=] + m.lcHeaderRow + [;";] > loConn.Open() > If loConn.State = 1 && connection open > loRS = CreateObject("ADODB.Recordset") > loRS.ActiveConnection = loConn > loCursor = CreateObject("CursorAdapter") > loCursor.Alias = m.lcSQLAlias > loCursor.DataSourceType = "ADO" > loCursor.DataSource = loRS > loCursor.SelectCmd = "SELECT " + m.tcExcelFieldList + " FROM [" + m.tcSheet + "] Where " + m.tcExcelWhereExpr > If !loCursor.CursorFill() > AError(laErr) > ERROR m.laErr[2] > EndIf > EndIf > Else > * Existing code to open ODBC connection ... > EndIf > **** New Code End **** > > IF USED(m.lcSQLAlias) > ... >