[AccessD] [dba-OT] Transfer field names to excel

[Jeff]

Did you try Find and Replace by Rick Fisher?


http://www.rickworld.com/products.html

I have used it to show used and unused fields in a table and to document table structure.  It says it will work up through Access 10, I used it last week on Access 2016.


Thanks,
Jeff

Sent from my iPhone

> On Oct 12, 2017, at 4:43 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> 
> Martin:
> 
> Lot of good tools there but didn't see one that would get the field names into an Excel sheet.  I'll keep looking, though.
> 
> 
> r
> 
> -----Original Message-----
> From: dba-OT [mailto:dba-ot-bounces at databaseadvisors.com] On Behalf Of Martin Reid
> Sent: Thursday, October 12, 2017 11:28 AM
> To: Off Topic; 'Access Developers discussion and problem solving'
> Subject: Re: [dba-OT] Transfer field names to excel
> 
> http://www.accessmvp.com/JConrad/accessjunkie/doctable.html
> 
> Various options
> 
> Martin
> 
> -----Original Message-----
> From: "Rocky Smolin" <rockysmolin at bchacc.com>
> Sent: ‎12/‎10/‎2017 19:18
> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>; "'Off Topic'" <dba-ot at databaseadvisors.com>
> Subject: [dba-OT] 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
> 
> 
> 
> 
> 
> 
>