SQL with no headers

  • Thread starter Thread starter Seth
  • Start date Start date
S

Seth

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
 
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
 
Back
Top