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 |
kprasadreddy
Starting Member
41 Posts |
Posted - 2005-10-06 : 10:14:56
|
I have an access query(access database) and want to dump the data from the query to sql server.What is the best way to do it...Also how can we schedule the query to run everyday?Thanks,Prasad |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-07 : 00:55:53
|
Look for OpenRowset and OpenDataSource in Books OnLine>>how can we schedule the query to run everyday?Make use of Job feature of SQL ServerMadhivananFailing to plan is Planning to fail |
|
|
|
|
|