[smooth]

Hey everybody

I have a link on my page that I want to use as a way of exporting my data in a SQL database to a CSV file. Such as when a user clicks the link, it brings up a save dialog for them to save it on their machine.

Here is a string of code I have:

If Request.QueryString("mode") = "exportleads" then
	Set rsUserAdmin = Server.CreateObject("ADODB.Recordset")
	strSQL = "bcp leads OUT leads.csv /c /t"
	rsUserAdmin.Open strSQL, conn
	Set rsUserAdmin = Nothing
	Set conn = Nothing
End If

This is giving me an error:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Cannot use the OUTPUT option when passing a constant to a stored procedure.

/admin/admin.asp, line 78

I also tried this:

If Request.QueryString("mode") = "exportleads" then
	Set rsUserAdmin = Server.CreateObject("ADODB.Recordset")
	strSQL = "SELECT * INTO OUTFILE leads.csv" & _
			  "fields terminated by '\t'" & _
			  "lines terminated by '\n'" & _
			  "FROM leads"
	rsUserAdmin.Open strSQL, conn
	Set rsUserAdmin = Nothing
	Set conn = Nothing
End If

But got the error:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near 'leads'.

/admin/admin.asp, line 81

I'm not sure which way to go with this. Any help would be appreciated