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

[Rocky Smolin]

That works except on my system it didn't export the table names.  But anyway, we have Stuart.  Who needs Microsoft?

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, October 12, 2017 3:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [dba-OT] Transfer field names to excel

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com