Extract data from MS SQL Server 6.5 database to ascii file

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."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

Exterpise Manager Select Export (ASCII,Excel,Access)?

Hi All. A client needs to send me some sample data. He has insisted he can query the table in Enterprise Manager via a simple select... "Select * from Table1"...

Now I need to get the data in some simple form (ASCII, Excel, Access, etc.) sent to me.

Can someone please provide me the info so I can pass it on for him to query a table from Enterprise Manager and "export it" to a simple file so I can receive it.

ANY THOUGHTS would be helpfull and GREATLY Appreciated!

Thanks.

BillIf this is a one timer I would go for "Tools -> Data Transformation Services -> Export Data".

// Pati|||Hey Pati... It may just be a one timer... but if the data looks good, it may be more frequent. it turns out some other process is taking records from this table, and may be removing them... Part of the reason we are trying to get some snapshots of the data.

I'm trying not to write an app until I know if we need this data.

Is it really simple to use to do the menu picks? Doesn't seem like the end user is very experienced, nor am I on Sql Server.

Thanks for the thoughts.

Bill|||If you think that you will need the same procedure again then you can save the DTS package for further use and then schedule it to run as desired.
...or then for another approach you could automate everything with scripts/scheduled jobs.

But as you're saying that you don't have much experience in SQL Server and that this might just be a one off solution then I would stick to DTS.

// Patisql