<div>
u can use the bop command to export to the csv file<br />
<br />
<br />
bcp mydb.dbo.UrTable out sales.csv /U /P /Ssales_svr /c /t<br />
<br />
Inorder to call this from an aspx page, u need to write a procedure containing this statement<br />
CREATE PROC ExprtExcel<br />
AS<br />
exec master..cmdShell 'bcp mydb.dbo.UrTable out sales.csv /U /P /Ssales_svr /c /t'<br />
go
</div>


u can use the bop command to export to the csv file


bcp mydb.dbo.UrTable out sales.csv /U /P /Ssales_svr /c /t

Inorder to call this from an aspx page, u need to write a procedure containing this statement
CREATE PROC ExprtExcel
AS
exec master..cmdShell 'bcp mydb.dbo.UrTable out sales.csv /U /P /Ssales_svr /c /t'
go

<div>
Ok, so let's say my database is called &quot;test&quot;, and the table I want to export is called &quot;sales&quot;. &nbsp;The SQL server is running on the localhost. &nbsp;What code would I put in an asp file to make this happen? &nbsp;I could go with either rendering the .csv in the browser, or having it actually create a file within the public web space. &nbsp;THanks!<br />

</div>


Ok, so let's say my database is called "test", and the table I want to export is called "sales".  The SQL server is running on the localhost.  What code would I put in an asp file to make this happen?  I could go with either rendering the .csv in the browser, or having it actually create a file within the public web space.  THanks!


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm a total newbie for the MS platform, and just inherited a Windows 2000 webserver running an app that uses the MS SQL server.<br />
<br />
I want to write a simple little script that when I hit it with a browser request, it will dump a given table to me in comma separated format (no matter how many columns there are). &nbsp;Is there a simple way to do this with an .aspx file?<br />

</div>
</div>


Hello,

I'm a total newbie for the MS platform, and just inherited a Windows 2000 webserver running an app that uses the MS SQL server.

I want to write a simple little script that when I hit it with a browser request, it will dump a given table to me in comma separated format (no matter how many columns there are).  Is there a simple way to do this with an .aspx file?


Dump db to CSV

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.