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 |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2004-08-23 : 17:02:08
|
| Can anyone assist me in figuring out how to take an entire table from my SQL Server 2000, and append all the rows to a DB400 table? I am at a loss here.- - - -- Will -- - - -http://www.servicerank.com/ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 17:05:42
|
| Do you have an ODBC driver for the DB400 system? If so, you can use DTS or linked servers.Tara |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2004-08-23 : 18:44:17
|
Yes. I have a couple ODBC drivers. I mostly use the Client Access driver because it gives me the least amount of problems. How can I go about using your solution?  - - - -- Will -- - - -http://www.servicerank.com/ |
|
|
|
|
|
|
Appending SQL Server Table Data to DB400 Table