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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-01-29 : 02:02:08
|
| can i have a stored procudure that when run - it will insert into my sql server table and also into an access db?anyway to make this work? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-29 : 02:22:34
|
| Use SSIS and just pump the data out. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-01-29 : 02:30:46
|
| no it has to be automatic - it's constant..this is temporary until we move the other access db to sql server as well but is there anyway? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-29 : 02:47:53
|
| Set the table up as a linked table?What do you mean by constant? You can not do an operation like this constantly unless it is in replication. |
|
|
|
|
|
|
can sql insert to access