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 |
|
akas
Starting Member
42 Posts |
 Posted - 2008-08-01 : 12:47:28
|
| Hi,i have one table in access 97, i want to import in sql server 2000...also when ever access 97 table updated i want to sql table updated automatically...means import and link to access database..how can i do that? any help?thanks.N.B. :- pls. don't reply that its duplicate post...as this is sql and access related so i posted my question in this forum too.thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-01 : 13:00:09
|
| the data import can be done with the help of DTS or OPENDATASOURCE. you could configure a job in sql agent to run the dts pacakge or the OPENDATASOURCE query and you can use sp_start_job to start the job. |
 |
|
|
|
|
|
Import question