Posted by Erland Sommarskog on 11/03/05 01:03

kosta.triantafillou@gmail.com (kosta.triantafillou@gmail.com) writes:
> Hey everyone, trying to set up a SQL Query to run on a pre-determined
> batch cycle that will automatically dump out specific table data to a
> .csv file so that users can load the file into Excel right away, with
> no manipulation or modification.
>
> We are running SQL Server 2000. I am a novice SQL user. Any
> suggestions?

Best is probably to set up a job in Agent that uses BCP to bulk out
the data. Do you want the entire table, or only part of it?


You can also try the Export/Import wizard and see what it gives you.
(Never have used it myself, though.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Updating a Chunk of data without crashing transaction log
• Prev in forum: Re: learning Microsoft Query Analyzer
• Thread view: Re: Automatic SQL Queries to dump data to folder

[Reply to this message]