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

Header Info

P: n/a
Roy
When I do the copyRecordset method via vba to transfer data from access
to excel template,i am unable to read the header info.It's only
transferring data.Any suggestions??

Roy

Apr 28 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Roy" <pr********@yahoo.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...
When I do the copyRecordset method via vba to transfer data from access
to excel template,i am unable to read the header info.It's only
transferring data.Any suggestions??

Roy


That is correct. If you need additional info you will need to get it from
the recordset object (which could be DAO or ADO). The recordset is made up
of fields each one having properties like Name and Type which allow you to
get at the meta-data, eg:

For each fld in rst.Fields
Debug.Print fld.Name
Next fld
Apr 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.