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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-09-27 : 23:20:32
|
| Hi All,I need to use DTS to transfer data to Access 2000. The data that I want to transfer are stored in 8 different tables. I need to transfer all these 8 tables to Access 2000. I knew that it is possible to have one DTS package and we can loop throught the tasks to transfer the 8 tables one by one, am I right? Can someone provide me with some steps how can I do this? Thank you.......... |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-28 : 00:39:35
|
| First of all, the quickest and easiest way to do this is to use the 'New Table -> Import' feature in Access. No need to worry about DTS. But, to answer your question, you can create a package that contains the 8 tasks required to transfer all the tables you require. Try using the Import/Export Data Wizard in EM. This will create a DTS package for you with little effort. |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2004-09-28 : 05:49:10
|
| Hi Timmy,Thank you for your suggestion. Basically, I use the second suggestion, which is create a package that contains 8 tasks to transfer all the tables. |
|
|
|
|
|
|
Transfer Data to Access 2000 with a Loop