Exporting all tables to text

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Exporting all tables to text

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

September 12th, 2003, 02:38 PM

Mitch

Friend of Wrox

Join Date: Jun 2003

Posts: 149

Thanks: 0

Thanked 0 Times in 0 Posts

Exporting all tables to text

Is there a way to export all the tables in a given database to a text file?

All at once? I know I can do it one at a time useing DTS, but i don't want to have to go through it for every table.

__________________
Mitch

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exporting related tables to excel	crisan	Access	10	July 24th, 2012 04:23 PM
Word Text Exporting in Crystal Through VB	fsmoin	Pro Visual Basic 2005	0	December 12th, 2006 04:13 AM
Exporting report to text file	naruto-kun	Reporting Services	0	August 15th, 2006 10:54 PM
STORING IMAGES & EXPORTING SQLSERVER TABLES	harsh_hot	MySQL	2	September 8th, 2005 02:10 AM
Exporting to Text	jcooper	Crystal Reports	0	March 2nd, 2004 06:40 AM