Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Copying Tables Through SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-06 : 11:23:43
Troy writes "I need to be able to copy tables and queries from one database to another. They are both Access databases. I tried to use a SQL statement through ASP, and it worked fine to copy the tables. However, the queries in the source database are copied to the destination database as new tables. Is there a way through SQL to copy the queries as queries when they are inserted into the destination database? If not, is there a graceful way to do it through ASP with ADOX?"
   

- Advertisement -