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
|
|||
|
|||
table name question
How can I export the table name in a mdb to an excel file? Thanks.
|
#2
|
|||
|
|||
table name question
DoCmd.TransferSpreadsheet
"00KobeBrian" wrote: How can I export the table name in a mdb to an excel file? Thanks. |
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |