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 |
|
wesleysim
Starting Member
1 Post |
 Posted - 2010-04-24 : 18:27:52
|
| Hi,I have problem with my asp page.I don't know how to creat connection for my sql database and ms.access.I want to select from my table in sql database and insert it into my ms.access database.Could you help me please?I try to use this syntax but it seed doesn't workINSERT INTO Members ( memberID, memberareaID )SELECT @memberID, memberareaID FROM MemberAreas WHERE areadescription = @areadescriptionThanks. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-24 : 18:54:56
|
| You could create a linked table in access, linked to the SQL Server table. Or you could create a linked server in SQL Server, linked to the access DB.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Multiple connection