Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer Database

Status
Not open for further replies.

dmorris

Technical User
Jun 8, 2004
3
US
I wrote a simple macro to transfer the data in one table to another table in a separate database. I cannot figure out how to then delete the data from the first table. I do not want the data in two places. I suspect I may have to create a module and write some code, but I have not done this before.
 

To remove the table use
con.execute("DROP TblName")

To delete the content of the table
con.execute("DELETE * FROM TblName")

Sunaj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top