| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Select string
Hi
I use ADO to get the first row of data from multiple unopened wbooks. This string gets the contents of every cell in row 1 given that SourceSheet = "Sheet1" and SourceRange = "A1:IV1" szSQL = "SELECT * FROM [" & SourceSheet$ & "$" & SourceRange$ & "];" Instead of all the row how can I write a string to result in specific names eg Last Name, Keycode, Company etc? T.I.A. Geoff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a string without knowing position | Excel Programming | |||
| select a string of characters | Excel Worksheet Functions | |||
| Word select from a string | Excel Worksheet Functions | |||
| select part of a cell value string | Excel Discussion (Misc queries) | |||
| Select option button when have the name as a string | Excel Programming | |||
Threaded Mode
