|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 24th, 2006, 08:42 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
table name question
How can I export the table name in a mdb to an excel file? Thanks.
|
|
#2
April 24th, 2006, 10:26 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
table name question
DoCmd.TransferSpreadsheet
"00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks.
|
|
#3
April 25th, 2006, 01:53 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
table name question
Sorry. This is not what I want. I mean to say if there are 50 tables in an
access mdb and I want to have them on an excel spreadsheet, how can I export them automatically instead of typing the 50 table names in excel spreadsheet? Thanks. "Martin" wrote in message ... DoCmd.TransferSpreadsheet "00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks.
|
|
#4
April 25th, 2006, 02:28 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
table name question
Something like data dictionary.
"00KobeBrian" wrote in message ... Sorry. This is not what I want. I mean to say if there are 50 tables in an access mdb and I want to have them on an excel spreadsheet, how can I export them automatically instead of typing the 50 table names in excel spreadsheet? Thanks. "Martin" wrote in message ... DoCmd.TransferSpreadsheet "00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks.
|
|
#5
April 25th, 2006, 04:09 AM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
table name question
Can anyone help? Thanks.
"00KobeBrian" wrote in message ... Something like data dictionary. "00KobeBrian" wrote in message ... Sorry. This is not what I want. I mean to say if there are 50 tables in an access mdb and I want to have them on an excel spreadsheet, how can I export them automatically instead of typing the 50 table names in excel spreadsheet? Thanks. "Martin" wrote in message ... DoCmd.TransferSpreadsheet "00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks.
|
|
#6
April 25th, 2006, 01:01 PM
posted to microsoft.public.access.forms,microsoft.public.access.formscoding
|
|||
|
|||
|
table name question
You mean you want a list of the tables in your database? The easiest way is
to query the system catalog: SELECT [Name] FROM MSysObjects WHERE Type In (1,4,6) AND Left([Name], 4) "MSys" ORDER BY [Name] -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "00KobeBrian" wrote in message ... Sorry. This is not what I want. I mean to say if there are 50 tables in an access mdb and I want to have them on an excel spreadsheet, how can I export them automatically instead of typing the 50 table names in excel spreadsheet? Thanks. "Martin" wrote in message ... DoCmd.TransferSpreadsheet "00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Table problem | Redwood | Database Design | 29 | April 3rd, 2006 04:58 PM |
| Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
| Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
| Survey Results | SAm | Running & Setting Up Queries | 10 | May 17th, 2005 08:32 PM |
| Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Linear Mode
