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. 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.
"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
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
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
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
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
"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
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
"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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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 >...
|
by: Dica |
last post by:
is it possible to generate an Exel file showing the results of an sql query
from an ASPX page?
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|
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...
| |