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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-27 : 08:01:20
|
| Vivek Gautam writes "I have some .mdb files on Server and I have to copy them to my machine automatically then I have to insert the data from that MDB files to sql table. I am not able to copy the mdb files from that server to my machine using sql." |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-28 : 06:46:20
|
Hi,no need to copy .mdb and then insert its data to sql 1). Import / Export Data using Import / Export Wizard2). DTSwill do this , and if you wants it to run automatically then schedule it , see sp_add_job for this.HTH -----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
|
|
|
Upload data