Hello,

I am querying an Excel column (via VB6) column in excel of format General whose 7 first items are numerical and the next values are Text

The following works well but returns only the numerical values

Code:
ObjConnection.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _ 
                       "Data Source=" & TempName & ";" & _ 
                       "Extended Properties=""Excel 12.0;HDR=YES;IMEX=1"";" 
Sql = "SELECT * FROM " & rs1
'rs1 refers coorectly to the column address

Is IMEX=1 in the ObjConnection not intended to deal with mixed format?

Please help
Avi