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

The Smiley Coder thesmileycoder at gmail.com
Fri Oct 13 01:36:40 CDT 2017


I should mention that I've heard several reports, that he is no longer
replying to requests on his site. I've not tried to verify this myself,
just wanted to give a word of caution.

Best regards
Anders Ebro // TheSmileyCoder <http://www.thesmileycoder.com>
Access MVP 2014-2018
<http://mvp.microsoft.com/en-us/mvp/Anders%20Ebro-5000469>

On Thu, Oct 12, 2017 at 11:57 PM, 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
>


More information about the AccessD mailing list