[AccessD] Transfer field names to excel

[Stuart McLachlan]

Yep, the discussions on OT are amazing!

On 12 Oct 2017 at 14:21, Rocky Smolin wrote:

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