table design view information
in [General]
|
From: NasaDBGuy on 13 Apr 2010 14:40 Is there a way to export the data in the design view of a table into another table or spreadsheet? I'm interested in getting the Field Name, Data Type and Description into a table. I can only copy one cell at a time.
From: Wayne-I-M on 13 Apr 2010 15:51 Yes Copy the table Past the Table (structure Only) into the new database - or the same DB with a new name -- Wayne Manchester, England. "NasaDBGuy" wrote: > Is there a way to export the information in the Design View of a table into > another table or spreadsheet? I'm interested in obtaining the Field Name, > Data Type, and Description fields.
From: Wayne-I-M on 13 Apr 2010 16:01 ooops Just re-read your post. Sorry my answer was not what you're looking for -- Wayne Manchester, England. "NasaDBGuy" wrote: > Is there a way to export the information in the Design View of a table into > another table or spreadsheet? I'm interested in obtaining the Field Name, > Data Type, and Description fields.
From: Jeff Boyce on 13 Apr 2010 16:59 Is this for something like "documentation"? If so, check on Access' database documenter... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "NasaDBGuy" <NasaDBGuy(a)discussions.microsoft.com> wrote in message news:810D134D-6939-4B9B-97FF-00C319910AE0(a)microsoft.com... > Is there a way to export the information in the Design View of a table > into > another table or spreadsheet? I'm interested in obtaining the Field Name, > Data Type, and Description fields.
From: KARL DEWEY on 14 Apr 2010 11:24 Try the Tools - Database tools - Analyze - Documentor. -- Build a little, test a little. "NasaDBGuy" wrote: > Is there a way to export the data in the design view of a table into another > table or spreadsheet? I'm interested in getting the Field Name, Data Type > and Description into a table. I can only copy one cell at a time.
|
Pages: 1 Prev: sto a prova se me manda le e-mail Next: table design view information |