data is downloading but is column headers are not displaying please help me out

[baig123]

data is downloading but is column headers are not displaying
i have created table called tblbatch_headers in database

1st (batch headers)column name --> wds next 2nd column as Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8,Field9,Field10...etc

Please Login or Register  to view this content.

[romperstomper]

CopyFromRecordset doesn't include the field names. You have to loop and add those yourself.

Please Login or Register  to view this content.

for example.

[baig123]

i want to display column headers as (WDS_id,.......)

[romperstomper]

What precisely is the problem?

You have a SQL string to return the headers from another table, you have another recordset and you have a line to put that recordset onto the worksheet (albeit all this code is commented out). What doesn't work?

[baig123]

i want the header should be displayed as column name(headers)---->
example
|wds_id | Field1 | Field2 | Field3 -->headers

1 dfnhj mndsb mndsb

it should come like this format

[romperstomper]

As far as I can see, I've answered that.

[baig123]

I am getting compile error

invalid or unqualified reference

Please Login or Register  to view this content.

[romperstomper]

Your loop is in the wrong place (you can't use a recordset before you open it) and missing a reference to rst2:

Please Login or Register  to view this content.