How to export the Web form results to Excel file?

ms.wcchan

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 language and how to write script to click the submit
button and all results will be saved to Excel file? When I open the
excel file, results from different customers will be saved in it and
all results will be written one by one.

Thank you very much

papatyam

Feb 4 '07 #1

Subscribe Reply

11925

Adrienne Boswell

Gazing into my crystal ball I observed ms*******@gmail .com writing in
news:11******** *************@j 27g2000cwj.goog legroups.com:

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 language and how to write script to click the submit
button and all results will be saved to Excel file? When I open the
excel file, results from different customers will be saved in it and
all results will be written one by one.

Thank you very much

papatyam

I don't know if you can directly save to an Excel file, but, if you use
a table, you can tell Excel to use that tables data. Look at the Data
column in Excel.

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Feb 4 '07 #2

McKirahan

<ms*******@gmai l.comwrote in message
news:11******** *************@j 27g2000cwj.goog legroups.com...

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 language and how to write script to click the submit
button and all results will be saved to Excel file? When I open the
excel file, results from different customers will be saved in it and
all results will be written one by one.

One suggestion is to just use FSO on ther server to create a CSV file
which you can subsequently double-click on to open it up in MS-Excel.

If you choose yo use MS-Excel then you should probably start with a
worksheet layed out the way you want it -- titles, column heading and
spacing, etc. When adding a row you'll have to identify the last row
used and insert the data in the next row. You'll also have a greater
concern with concurrent updates; that is, two users submitting their
results at the same time.

Feb 4 '07 #3

McKirahan

"McKirahan" <Ne**@McKirahan .comwrote in message
news:7p******** *************** *******@comcast .com...

<ms*******@gmai l.comwrote in message
news:11******** *************@j 27g2000cwj.goog legroups.com...
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.

[snip]

Also, is MS-Excel installed on the server?
Likely not if you're using a hosting service.
If it is installed, is it accessible from ASP?

Feb 4 '07 #4

Adrienne Boswell

Gazing into my crystal ball I observed "McKirahan" <Ne**@McKirahan .com>
writing in news:_8******** *************** *******@comcast .com:

"McKirahan" <Ne**@McKirahan .comwrote in message
news:7p******** *************** *******@comcast .com...
><ms*******@gma il.comwrote in message
news:11******* **************@ j27g2000cwj.goo glegroups.com.. .
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.

[snip]

Also, is MS-Excel installed on the server?
Likely not if you're using a hosting service.
If it is installed, is it accessible from ASP?

You don't have to have Excel on the server. All you have to do is:
Data -Import External Data -New Web Query. You can create a
spreadsheet from any web page. Hopefully, the author (of the page) has
not abused tables and the data is in one single table.

I am doing this for my boss, because she does not want to go to the url
where the data is stored coming out of a database. It's eaiser for me
to write to the table and get the results.

Another alternative is to write the results to a csv file and import
that into Excel.

To the OP: Frankly, the best bet is to write to a db table. Use the
right tool for the job -- Excel is for spreadsheets, Access is for data,
Word is for documents, FrontPage is _not_ for creating pages for the
WWW.

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Feb 5 '07 #5

Similar topics

5041

Export to Excel

by: Matt | last post by:

I have an ASP page that calls ASP routines that I created that execute a database query and return the results to a recordset. I then iterate through the recordset and display the data in a table. Before I iterate through the recordset I instruct the browser that the content type is Excel using the following line: (Response.ContentType = "application/vnd.ms-excel") This works fine with Excel 2003 but with older versions (I tested Excel...

ASP / Active Server Pages

1374

Export to Excel in MS Access

by: Rohit | last post by:

Hi, I have one form in access application which shows various fields from the database. The fields are like No of PCs a client has,No of employees,revenue etc. Need of the user is to filter the data on the form and export the results. I am using a Qury as the base for this form.Can I do it easily or i need to write the code to do this.

Microsoft SQL Server

3387

Export to a Datagrid, YET AGAIN!

by: Kevin Blakeley | last post by:

I know this was just posted but I did not want this message to get lost in the other thread as it's slightly different. Yes I want to export my dataset to excel for my clients, but I don't want it to show in the browser. Everything I have tried makes it so that IE will load excel within the browser session and view the file in there. What I want is for the user to be prompted with the save dialog to save the excel file disk. How do I...

ASP.NET

6455

CSV Export: Force Trailing Comma?

by: bonehead | last post by:

Greetings, I'm using the DoCmd.TransferText method to export the results of a MS Access query to a csv file. The csv will then be used to load an Oracle table. In other systems such as TOAD for Oracle, it's possible to force an additional comma delimiter after the last column, if the column is empty on a particular row. Oracle requires this additional comma on empty rightmost columns, for importing purposes.

Microsoft Access / VBA

31927

Export a query to Excel

by: Simon | last post by:

Dear reader, With the export command you can export a query to Excel. By activate this command a form pop's up with the following text:

Microsoft Access / VBA

9780

Access Tables to Excel Worksheet Export

by: smaczylo | last post by:

Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm having I'd be most appreciative. The database is already constructed, I'm just wanting to export the data to an excel file. In short, I'm hoping to export two Tables (or queries...not sure which to use - they both seem to have the same data) in...

Microsoft Access / VBA

10513

Export Access query to Excel using a command button on an Access form

by: CoolFactor | last post by:

MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am trying to export to Excel using a command in an Access Form. RowID strFY AccountID CostElementWBS 1 2008 1 7 2 2008 1 7 I want to...

Microsoft Access / VBA

28910

How To Export Your Displayed Data To Excel

by: Merlin1857 | last post by:

Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can actually do something more with. This code shows you how to display data from your database and then how to give that data to the user in the form of a useable Excel spreadsheet which they can then take away and play with themselves. The way I have shown...

ASP / Active Server Pages

4047

Specifying Directory and File Name on Pivot Table Export from Access query to Excel

by: Marisol2 | last post by:

I have some queries in Access 2003 db that I have setup to display as pivots. I can go into design pivot table view and click on and then click on Export to Office MicroSoft Excel. The problem is I have about 6 queries that produce 48 reports (based on parameters). I don't want to manually save each pivot query results. The first macro I created to export the queries I used TransferSpreadsheet but the export results are regular xls...

Microsoft Access / VBA

9708

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9588

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10340

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10327

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9161

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7625

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5663

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4302

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3828

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP