I am trying to export ASP charts into excel spreadsheet or .ppt slides.
For excel, I included this line in my ASP page:
Response.ContentType = "application/vnd.ms-excel"
When I executed, I got this error:
***************************************
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.
****************************************

I got no error if I left that line out.

As far as exporting to .ppt slides, I have no idea.

I want to thank you in advance for any input you provide.

Article on Making charts in ASP :: http://www.asp101.com/articles/chris/aspcharts/

FYI, any chart creating tool would generate a .gif file after processing the application. So it would be apt to check the code samples included with the tool (like ChartFX or ASPChart).

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

It looks like you have a syntax error, can you post the line of code refered to in your error and your final SQL Statement before it hits the database ?

Also worth a look is http://www.greggriffiths.org/webdev/both/excel/ which covers ASP->Excel.