How to copy structure of a table to another database 
Author Message
 How to copy structure of a table to another database

Hi,

Does anyone know how to copy only the structure of a table (not the
data) from one Access database to another using either SQL or  DAO?

Thanks

Ray



Thu, 25 Mar 1999 03:00:00 GMT  
 How to copy structure of a table to another database

Quote:

> ...
> Does anyone know how to copy only the structure of a table (not the
> data) from one Access database to another using either SQL or  DAO?

See help for TableDef object. Not directly mentioned as a TableDef's
properties (but shown in the picture) are its Fields and Indexes
collections, so don't forget about them!

--

Vox (0|+44)1642 216 200  }*|*{  *o|o*  }o|o{ Zetland Buildings, Exchange Square
Fax (0|+44)1642 216 201    o      o      *   Middlesbrough, Cleveland.  TS1 1DE
"Imitation is the sincerest form of being a thieving bastard." -- somebody else



Mon, 29 Mar 1999 03:00:00 GMT  
 How to copy structure of a table to another database

There is sample code in the visdata.mak (VB 3.0)



Mon, 29 Mar 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

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

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

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

4. MS Access DB - Copy Table A from Database A to Table A Database B

5. copy table structure

6. Copying table structures in code

7. Newbie: How to copy Table structure?

8. Copy Foxpro 2.6 table structure

9. Creating .MDB in ADO; copying a table structure

10. Copying Table structures

11. Newbie: How to copy Table structure?

12. Q. How do I copy a table structure

 

 
Powered by phpBB® Forum Software