Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO with mixed data
Hello,
I am querying a 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 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO with mixed data
Hello,
I am querying a 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 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? Why do you think it needs to be there at all? Please help Avi -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO with mixed data
To deal with mixed type data...At least what I was thinking
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixed Data in column | Excel Discussion (Misc queries) | |||
Charting mixed data | Charts and Charting in Excel | |||
separate mixed data | Excel Programming | |||
SORT MIXED DATA | Excel Worksheet Functions | |||
Mixed Data Handling | Charts and Charting in Excel |