| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL <SELECT with condition
hi Can anyone help me with this problem? i am a newbie for VBA programming. My excel cell look like this A B 1 user description 2 83 london 3 84 usa 4 45 italy 5 84 Rome The sheetname is called data How do i write an SQL statement to Extract the description where the user is 84 SELECT * FROM [data$] Where user='83' I have an error when executing with ADODB.Recordset: " Data type mismatch in Criteria Expression" Runtime error ' -2147217913 (80040e07)' Thank you -- brucelim80 ------------------------------------------------------------------------ brucelim80's Profile: http://www.excelforum.com/member.php...o&userid=32244 View this thread: http://www.excelforum.com/showthread...hreadid=520460 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| programming to select rows based on condition | Excel Discussion (Misc queries) | |||
| How to select the value based on given condition? | Excel Discussion (Misc queries) | |||
| How to select certains records meeting a certain condition !!!! | Excel Worksheet Functions | |||
| How to randomly select from a list with condition | Excel Worksheet Functions | |||
| Excel formula: select value in column if condition in 2nd col met | Excel Programming | |||
Threaded Mode
