Copying the structure of one Access table to a new Access table 
Author Message
 Copying the structure of one Access table to a new Access table

Hi all,

Using VB6 sp4 I am connecting to Access 97 databases to view the contents of
a particular table.  I want to be able to move records from this table to a
different table.

Now here is the question.  I want to be able to copy the structure of the
table I am viewing to a new table with a different name.  This new table
will then hold the records I want to move.

Is there an easy way to do this using ADO 2.5?

Thank-you

Regards,

Paul



Sun, 23 Feb 2003 22:40:31 GMT  
 
 [ 1 post ] 

 Relevant Pages 

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

2. Exporting Tables From One Access DB to a New One

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

4. To Copy table from one Access database to other

5. Copying one Access table into another

6. Copy Access/Oracle table from one DB to another DB.

7. ADO Copy Tables from One Database to Another (Access 97)

8. Copy external data structure to new table

9. Copy Recordset to New Access Table

10. copy dbase table to access table

11. Copy Dbase table to Access Table

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

 

 
Powered by phpBB® Forum Software