Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL with no headers
How do you use a WHERE statement if a table has no
headers? i.e., say there is a table called "EMPLOYEES"...I know that the first column is FirstName and the second column is LastName, but these are not headers...so the recordset simply starts with the first name in the range. Is it possible to use a WHERE criteria with no headers in this case? I don't know how to identify the fields when there are no headers. Thanks, Seth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL with no headers
If your data is in a recordset and that is an extract
from a SQL database, then there are 'headers, ie column names. One cannot create a table in any database without column names. If your data is in a recordset called RST then you can get the 'headers' with a simple for.next loop:- WITH RST For i = 0 to .Fields.Count - 1 Cells(1,i+1).Value = .Fields(i).Name Next END WITH Range("A2").CopyFromRecordset RST HTH Patrick Molloy Microsoft Excel MVP -----Original Message----- How do you use a WHERE statement if a table has no headers? i.e., say there is a table called "EMPLOYEES"...I know that the first column is FirstName and the second column is LastName, but these are not headers...so the recordset simply starts with the first name in the range. Is it possible to use a WHERE criteria with no headers in this case? I don't know how to identify the fields when there are no headers. Thanks, Seth . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
HEADERS HELP PLEASE! | Excel Discussion (Misc queries) | |||
headers | Excel Worksheet Functions | |||
Headers | Excel Discussion (Misc queries) | |||
Row Headers | Excel Discussion (Misc queries) |