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 |
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 . |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com