Board index » VBA

All times are UTC



 copy table structure 
Author Message
John Jaco
#1 / 2
 copy table structure

I want to copy a table's structure but not its data.  DoCmd.CopyObject
copies both the structure and the data.  If I go to the database window and,
with the mouse, copy the table and then paste, I'm given the option of
pasting the structure and data, or only the structure.  How can I copy only
a table's structure using VBA?


Mon, 11 Mar 2002 03:00:00 GMT  
Nigel Elli
#2 / 2
 copy table structure
Use the DoCmd.TransferDatabase option. When copying a table you have the
option of copying the table structure only.

--
Any advice, views or opinions are offered  by me, not the company


Quote:
> I want to copy a table's structure but not its data.  DoCmd.CopyObject
> copies both the structure and the data.  If I go to the database window
and,
> with the mouse, copy the table and then paste, I'm given the option of
> pasting the structure and data, or only the structure.  How can I copy
only
> a table's structure using VBA?



Mon, 11 Mar 2002 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Copying table structures in code

2. Newbie: How to copy Table structure?

3. Copying Table structures

4. Newbie: How to copy Table structure?

5. Copy Table Structure

6. Copying table structure w/ code

7. copying table structure with Openschema

8. HowTo Copy a Recordset from a Table to an identically structured table

9. Copying the structure of a table to a new table

10. Copying the structure of one Access table to a new Access table

11. VB5 & Access 97 Copy Table Structure from One MDB to Another

12. Copy Foxpro 2.6 table structure

  

 
Powered by phpBB® Forum Software