[AccessD] Transfer field names to excel

Bill Patten bill_patten at outlook.com
Thu Oct 12 14:43:21 CDT 2017


Rocky,

I don’t know if you subscribe to dba-OT but if you don't Martin Reid replied to you with this URL stating it had various options.

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

HTH

Bill

-----Original Message-----
From: Rocky Smolin
Sent: Thursday, October 12, 2017 11:17 AM
To: 'Access Developers discussion and problem solving' ; 'Off Topic'
Subject: [AccessD] Transfer field names to excel

Dear list(s):



Is there an easy way to transfer the field names of a table to an excel
spreadsheet?



I have 11 tables and I would like the field names of all of them to be in 11
columns of a spreadsheet.  Each table has about 15 fields.



I could copy and paste them, it's not an overwhelming number. Probably take
½ hr. or less.  Which may be faster (although not as much fun as writing a
bit of code to push the field names onto a spreadsheet.)



But is there an easier more automated way to do this?



MTIA

\

\

Rocky Smolin

Beach Access Software

760-683-5777

<http://www.bchacc.com> www.bchacc.com

<http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin





--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list