| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Select Statement in Excel
Look at my answer to the post of 2 December 2005:
Count duplicates in an array? RBS "agustina_s" wrote in message ... Hi is there anyway to create macro/ VBSCript to execute SQL Select statement in Excel Column. Eg. Select FirstName where LastName in ('Smith','Anderson') I have an excel spreadsheet1 with Column A = FirstName and B = LastName And then in another spreadsheet2 I want to look up value to spreadsheet1. Is there any tutorial regarding this? I tried to search for it but to no avail :S. Any suggestion is welcome. Thanks in advanced. Regards Agustina -- agustina_s ------------------------------------------------------------------------ agustina_s's Profile: http://www.excelforum.com/member.php...o&userid=30094 View this thread: http://www.excelforum.com/showthread...hreadid=497813 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement to select a letter | Excel Worksheet Functions | |||
| select case statement | Excel Programming | |||
| SELECT statement | Excel Programming | |||
| SQL Select statement with Date as | Excel Programming | |||
| Adding SQL Select Statement | Excel Programming | |||
Threaded Mode
