Making a copy of an existing table? 
Author Message
 Making a copy of an existing table?
Tim:

"SELECT [MyOldtable].* INTO [MyNewTable] FROM [MyOldTable]"

Hope this helps

Sebastian


Quote:
> How do I copy an existing table to a new table with a different name?

> Tim Beck



Wed, 24 Apr 2002 03:00:00 GMT
 Making a copy of an existing table?

This alone will not "copy a table".  It is simply taking the data portion
alone and setting it into a new table without any special attributes the
prior table included such as indexes. You have to rebuild these yourself
afterwards.

Al Meadows



Sat, 27 Apr 2002 03:00:00 GMT
 Making a copy of an existing table?
So you just have to get all the attributes of the original and build the new
table then do the data movement.

Seems like a hassle but it's really not, esp if you use DAO since the Object
model is simple comapred to aADO's non-model.  Write it as a generic class
or module and use it to automate the process at any time with any table.

For source code that might get you started on running thru the current
table's details (and creating a "definition" for the copy table):

http://www.smithvoice.com/jet.htm

Hope it helps

-Robert Smith
Kirkland WA

Quote:

>This alone will not "copy a table".  It is simply taking the data portion
>alone and setting it into a new table without any special attributes the
>prior table included such as indexes. You have to rebuild these yourself
>afterwards.

>Al Meadows



Sat, 27 Apr 2002 03:00:00 GMT
 Making a copy of an existing table?
How do I copy an existing table to a new table with a different name?

Tim Beck



Mon, 29 Apr 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. need to copy existing Access data into existing SQL tables, maintaining identity values

2. need to copy existing Access data into existing SQL tables, maintaining identity values

3. Script to copy data from one existing column to a new column in another existing table

4. Making tables off of existing table

5. making a PK identity on an existing table

6. Making a copy of a table

7. Making a copy of an access table

8. How to copy a record in existing table

9. copying existing tables?!

10. Making sure a record does not exist

11. making new recordset from existing recordset

12. Making an ERD from an existing db


 
Powered by phpBB® Forum Software