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 |
|
badua
Starting Member
8 Posts |
 Posted - 2004-04-18 : 11:10:31
|
| Hello,Could anyone here tell me the way to DTS from a local SQL server to a MS Access on a remote subscribed Web server? It's necessary that MS Access file has to be made as ODBC? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-18 : 20:43:36
|
| Access databases are reached through the file system, so yes you would have to open up ODBC.Damian |
 |
|
|
badua
Starting Member
8 Posts |
Posted - 2004-04-19 : 03:43:20
|
| Yes, Webserver admin can help me open ODBC. But how I have to do so as to transfer data from a local SQL server? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-19 : 03:47:08
|
| In enterprise manager, find the "Import / Export data" wizrd by right clicking on tables. It should make sense.Damian |
|
|
|
|
|
|
DTS from a local SQL server to a MS Access?