By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Export Header

P: n/a
Roy
Hello,
While I am able to export the records via the DAO using the
CopyRecordset method,I am unable to export the header info.

I use the code example as stated below:

For iCols = 0 to rs.Fields.Count - 1
ws.Cells(1, iCols + 1).Value = rs.Fields(iCols).Name
Next
ws.Range("A2").CopyFromRecordset rs

My range starts at row 20 and col 32.I don't know where my code fails
because it does'nt come with a error but also no header names are
exported.Any clues?

Roy

May 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.