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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 exporting data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-11 : 08:05:30
Dody writes "could you tell me how to export table data in sql7 to excel with not using wizard like dts?
I badly needed the information ....
THANK'S ALOT...."

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-12-11 : 09:06:52
You can create DTS-packages without using the wizards. Use either the graphical DTS-designer, or if you prefer, code it in VB using the DTS object model.

You can also use a linked server, look at sp_addlinkedserver in BOL.
Go to Top of Page
   

- Advertisement -