Deleting, Importing, and renaming tables in an access database

[Paladyr]

If I open a connection to a database, how do I code a delete table, or import a table from another database, or rename a table using ADO??? I just need to know the syntax for it. Thanks for the help!

 

[Paladyr]

Is there no way to do this?

 

[Paladyr]

Okay, I figured out how to delete the entire contents of a table, but still haven't found a way to "import" all of the data from another identical table into a table of the same design in a different database. It is basically just a customer table. Linking the table is not an option. The whole design of these databases is horrible so I want to keep them all seperate for now. I guess I could just loop through all the records and copy the data from each field into a string, then import it field by field into the table. I just figured there was a way to import a table's contents into another table. If anyone could give any help it would be greatly appreciated!

 

[Paladyr]

Okay, I still really need to know how to do this, or if there is even a way!!! Does anyone have any clue if this is possible?

 

[Paladyr]

Is there any way at all of doing this, even without ADO????

 

[Databaseguy]

You posted this in the Access forum, No ??? Did you get your answer ?? Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy