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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 20:17:21
|
Luis writes "I am programing ASP pages with access databases.
I open databases with sentence like:
cnTemp.Open "driver={Microsoft Access Driver (*.mdb)};dbq=test1.mdb"
I need to select record from one database connection (test1.mdb) and insert them into a new or maybe add them to an existing table in other database comnnection (test2.mdb)
What is the correct SQL syntax?
Best Regards." |
|
|
|
|
|
SELECT ... INTO ... IN ... question