[AccessD] Transfer field names to excel

[Rocky Smolin]

Thanks Bill.  I'm a charter member of OT - proud to say we got kicked off of AccessD by the moderators in 2000 for too much off topic about the election.  Interesting list.  You should lurk it some time. You might find it entertaining. We'd be happy to have you. :)

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten
Sent: Thursday, October 12, 2017 12:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transfer field names to excel

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com