Re: Extract data from MS SQL Server 6.5 database to ascii file
From: Bob Simms (bob_simms_at_somewhere.com)
Date: 03/26/04
- Next message: Bob Simms: "Re: ntext vs. binary"
- Previous message: Bob Simms: "Re: Can not delete data from View"
- In reply to: Susie: "Extract data from MS SQL Server 6.5 database to ascii file"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Mar 2004 07:17:37 -0000
"Susie" <anonymous@discussions.microsoft.com> wrote in message
news:138b401c412b4$39088750$a401280a@phx.gbl...
> I am trying to extract the data from our MS SQL Server 6.5
> database to an ascii file. I need to have the data in the
> columns enclosed in double quotes ( " ) and terminated by
> a comma ( , ). Does anyone have any usefull information
> on doing this. I am looking for a tool or a script. I
> don't want to write multiple bcp out statements and I am
> unsure how to enclose the data from the columns in double
> quotes. Any information will be greatly appreciated.
You could try looking at DTS. Create a package with the Import/Export
Wizard, then tweak it in the DTS Designer
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004
- Next message: Bob Simms: "Re: ntext vs. binary"
- Previous message: Bob Simms: "Re: Can not delete data from View"
- In reply to: Susie: "Extract data from MS SQL Server 6.5 database to ascii file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
