[AccessD] [dba-OT] Transfer field names to excel
Rocky Smolin
rockysmolin at bchacc.com
Thu Oct 12 17:54:17 CDT 2017
I have F&R but don't see a feature to export a table's field names. Is there something there I am missing?
Thanks
R
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff
Sent: Thursday, October 12, 2017 2:58 PM
To: DBA-AccessD
Subject: Re: [AccessD] [dba-OT] Transfer field names to excel
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
>
>
>
>
>
>
>
--
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