473,326 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Results to Excel

How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.
Jul 10 '07 #1
10 1650
Use Response.ContentType("application/vnd.ms-excel")

"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.
Jul 10 '07 #2
"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.
One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft Access,
as that you involve server-side automation, which isn't supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #3
I want the information to come to my computer in table or grid form, so that
I can make reports at will.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.

One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn't
supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #4
Would Excel have to be installed on the host server? In some of the links
below it appears that it does not.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.

One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn't
supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #5
My understanding is that you want to use Excel to create reports.

You could render them using Xml :
http://support.microsoft.com/kb/319180/en-us

The first step is likely to first choose which version you'll support (XML
support started with 2002, but is enhanced with each new version and you
still may have some limitations, for example you likely can't have graphics
in 2002 xml files).

--
Patrice

"dancer" <da****@microsoft.coma écrit dans le message de news:
%2****************@TK2MSFTNGP04.phx.gbl...
>I want the information to come to my computer in table or grid form, so
that I can make reports at will.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl...
>"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
>>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.

One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn't
supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Jul 10 '07 #6
No, for the page to be displayed correctly, it has to be installed on the
client.

"dancer" <da****@microsoft.comwrote in message
news:Oz**************@TK2MSFTNGP05.phx.gbl...
Would Excel have to be installed on the host server? In some of the links
below it appears that it does not.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl...
>"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...
>>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.

One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn't
supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #7
"dancer" <da****@microsoft.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
>I want the information to come to my computer in table or grid form, so
that I can make reports at will.
So, you want your web page to generate a grid of data...

And then what? Are you expecting your web page to create an Excel workbook
(.xls) which the user will download and then open...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #8
No, Excel would not create the reports. I would create the reports using
Merge capabilities in Microsoft Word, with a table in Excel as my data to
merge. I don't know how to get the data from the website to my computer.
"Patrice" <http://www.chez.com/scribe/wrote in message
news:Or**************@TK2MSFTNGP06.phx.gbl...
My understanding is that you want to use Excel to create reports.

You could render them using Xml :
http://support.microsoft.com/kb/319180/en-us

The first step is likely to first choose which version you'll support (XML
support started with 2002, but is enhanced with each new version and you
still may have some limitations, for example you likely can't have
graphics in 2002 xml files).

--
Patrice

"dancer" <da****@microsoft.coma écrit dans le message de news:
%2****************@TK2MSFTNGP04.phx.gbl...
>>I want the information to come to my computer in table or grid form, so
that I can make reports at will.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:u4**************@TK2MSFTNGP02.phx.gbl...
>>"dancer" <da****@microsoft.comwrote in message
news:uG**************@TK2MSFTNGP05.phx.gbl...

How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.

One step back here - what exactly do you mean by "reports"...?

Clearly you can't be talking about the reporting engine in Microsoft
Access, as that you involve server-side automation, which isn't
supported...

Adding data to an Excel spreadsheet is simple enough:
http://www.google.co.uk/search?sourc...22ADO%2eNET%22

But then what...? Do you intend to display this spreadsheet in the
browser...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net



Jul 10 '07 #9
"dancer" <da****@microsoft.comwrote in message
news:ul**************@TK2MSFTNGP04.phx.gbl...
No, Excel would not create the reports. I would create the reports using
Merge capabilities in Microsoft Word, with a table in Excel as my data to
merge. I don't know how to get the data from the website to my computer.
Presumably, then, this is just for your own use, not for a client...?

If it is for a client, you really would be well advised to forget the Office
suite of products completely - there are dozens of excellent reporting
utilities available for ASP.NET, none of which requires any data to be
downloaded to the client machine at all, e.g.

http://www.gotreportviewer.com/
http://www.siberix.com/

etc
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 10 '07 #10
On Tue, 10 Jul 2007 10:38:24 -0400, "dancer" <da****@microsoft.com>
wrote:
>How can I save the results of a fill-in form to a Microsoft Excel
spreadsheet?
I can insert the results into an Access table, but the reports are so
tedious to make from Access.
Reports are very easy to make using Excel as the data source.
Since there will not be multiple tables or queries, I don't really need
Access.
A Google search on "asp.net excel download" gives several pages of
results which are most all variants on these - especially the first.

1) Put the data in a DataGrid or GridView on your server and then
sending the control to the client with the appropriate headers. This
method is quite well detailed and probably most widely used. The data is
sent as HTML but is recognised by Excel, on the client, as a
spreadsheet.

2) Send the data as XML.

3) Sending a native Excel file - has no real advantages unless the
client only has an Excel viewer installed.
Jul 11 '07 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Suffrinmick | last post by:
Hello Everyone I've built a database using Access 2000 which includes a query which is built using a form containing filters. No problem. When I export the results of the query to excel, (File >...
4
by: Dica | last post by:
is it possible to generate an Exel file showing the results of an sql query from an ASPX page?
0
by: tomslater2003 | last post by:
Hi! I wanted to know if there is any possibilites to export search results of a particular webpage to excel? I have a website where in search for a specific criteria. After selecting the...
4
by: roman.ali | last post by:
Hi, I am using a .dqy file to import some rows from a sql server 2003 database to microsoft excel. Unfortunately, I have am importing more rows than excel can handle. Is there a way around...
1
by: gabe | last post by:
Hello as a user of some intranet corporate ASP application, I face some hard times filling up some asp-pages forms to get some data out of the server. It happens than you need to feel up many forms...
2
by: Mad Scientist Jr | last post by:
>From an asp.net web page I want the user to open the results of a SQL query in Excel, as automatically as possible (ie not having to loop through columns, rows, in code). For this,...
4
by: ms.wcchan | last post by:
Dearest I.T. professional, I am now doing a survey and would like to ask all customers to submit the questionnaire online so that I can collect the results in the excel file. What programming...
4
by: Belgarath | last post by:
Hello all, I'm a newbie in Access... And before starting to explore this software, I would like to know if it's possible to automate everyday queries result in Excel . If it's possible can...
0
kmartinenko
by: kmartinenko | last post by:
Hi all, I have come up with a solution on how to read a .csv file, perform a simple command on the values in one of the columns and then print the results onto the command prompt screen But...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.