[AccessD] Transfer field names to excel

Rocky Smolin rockysmolin at bchacc.com
Thu Oct 12 17:54:41 CDT 2017


Well, pretty amazing.

r

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

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



-- 
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