Hi There,

I have searched through the Survey Module...but I couldn't seem to find the answer.  Is it possible to export or download the survey results to Excel?  I know we can export the content...but it's not pretty.

It seems I would need an xml converter fils xsl (i think)...is this my only option?  Anything in the works to allow the download to excel of the survey results?

Thanks so much,

Jen

Jensta:

There is a quick and dirty solution to what you need to do, I ran into it by coincidence yesterday (and I want to emphasize quick and dirty).  You must run the statement below on the server where SQL is running.

use YourDNNDatabase;
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\SurveyOut.xls;',
'SELECT * FROM [Sheet1$]')
select * from Surveys

There are a couple of things you must do for this to work.  First, you must create the file on the server before running the command or you'll get an error.  Second, you must enter the column names for the columns of the SQL table you will be exporting on the first row of the spreadsheet as column titles.  Notice that your SQL statement against the DNN database is the last line.  You can specify the columns you need but remember that the column names in the first row of the Excel file must match the column names of the SQL result.  Make sure the file is not open in Excel before running the command.

I tested this statement on SQL 2000 and 2005 and it worked fine.  In 2005 however, you must run the "SQL Server Surface Area Configuration" utility and allow "Ad Hoc Remote Queries" (for Enable OPENROWSET etc.)

I also found a piece of code to export data to Excel (or Word) from ASP.Net without having to create the file before hand.  I may put together a module for this later.

Carlos