| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Select Statement in Excel
Hi is there anyway to create macro/ VBSCript to execute SQL Selec 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 t 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 Agustin -- agustina_ ----------------------------------------------------------------------- agustina_s's Profile: http://www.excelforum.com/member.php...fo&userid=3009 View this thread: http://www.excelforum.com/showthread.php?threadid=49781 |
| 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
