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

Gary Kjos garykjos at gmail.com
Thu Oct 12 17:57:57 CDT 2017


I just use the database documenter tool and export the document to
excel and copy and paste from there.

GK

On Thu, Oct 12, 2017 at 5:55 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> Well, don't do that Paul.  That was one of my options.  It's a fun piece of code to write. But I may not need it that badly.  Gonna talk to the client tomorrow before I go any further (on my dime).
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland via AccessD
> Sent: Thursday, October 12, 2017 3:21 PM
> To: Access List
> Cc: Paul Hartland
> Subject: Re: [AccessD] [dba-OT] Transfer field names to excel
>
> I could probably get you some code tomorrow, I would go about it using the tabledef object to loop through the tables, then inside every loop, loop through the fields of that tabledef object writing each out to an excel file
>
> On 12 Oct 2017 22:58, "Jeff" <jeff.developer at gmail.com> wrote:
>
>> 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
>>
> --
> 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



-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list