Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing and Exporting data

Status
Not open for further replies.
SQLSister

SQLSister

Programmer
Jun 18, 2002
7,292
US
For those who are new to SQL Server, this is where you go for information on importing and exporting data in SQL Server. This is done using a tool called DTS (Data Transgformation Services). BCP questions can also be posted here.
 
Sort by date Sort by votes
I need help to write a stored proc to use dts to export data to an excel file. Can any body help?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
191
gk53
gk53
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
2
Views
110
drlex
drlex
MICKI0220
  • Locked
  • Question
Overflow problem when importing to sql 2008
Replies
0
Views
67
MICKI0220
MICKI0220
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
283
markjoseph1232
markjoseph1232

Part and Inventory Search

Sponsor

Back
Top