Transfer Data From Page To Excel
I have an asp page that collects data from a database and then displays it in a table on the page. I also want to be able to put this information into excel. I know how to get the page to load up in excel and then display the data using the following command -:
response.contentType = "application/vnd.ms-excel"
however I want it so that there is an Extra button on the page that the user can press to transfer the data accross. Does anyone know how to do this?
View Replies
ADVERTISEMENT
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
View Replies
View Related
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="">
<P>
Software: <INPUT name=text1 >
<input type="submit" name="Submit" value="Find">
<%
on error goto 0
If Request.Form("Submit") = "Find" Then
description = Request.Form("text1") .....
View Replies
View Related
My asp/sql server application gets an error, but only when you use the
Excel export option:
<% Response.ContentType="application/vnd.ms-excel" %> (very popular w/
users)
I think somebody entered a string of characters that Excel does not
like:
So I believe (but not sure) some character(s) in a Ntext sql server
field "desc_text" is confusing the Excel file and causing it to error
(and crashes Excel)
So far, I have attempted three fixes with no success
1) Tried to convert the data type in the SQL query:
CAST(sr.desc_text AS VARCHAR(255))
2) Tried to convert the data type in the vbscript:
<% desc_text1 = Cstr(rs.fields.item("desc_text").value)%>
3) Tried append an apostrophe to the beginning of the field so that
Excel would not read it as a formula. (this might have worked, but
Excel does not treat an apostrophe the same from an export as it does
if you typed it in directly)
<%response.write "'"%> <% response.write desc_text1%>
Soliciting all ideas!
Also, if you have any ideas on how to isolate and identify the
specific record and character(s) that is causing the error, that would
be great. I have it narrowed down to a record set of 600 records, and
the error occurs if I include beyond the 130th character position. The
problem does not occur if I use CAST(sr.desc_text AS VARCHAR(129))
View Replies
View Related
I am trying to figure out how to allow a person to select a file on their local machine and then read that file and transfer the data into SQL.
View Replies
View Related
I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
View Replies
View Related
I am creating a database and it has to be up dated from all over the county.But Unfortunately there are some users who have only telophone connection not internet connection. Is ther any way that I can allow them to up-date my database using telephone line i/o interne.
View Replies
View Related
Can you pleaseeee let me know if what I am attempting to do is possible? ....and how. I have a Access database at backend of my ASP site. Is there a way in which I can design a page which will pick up only the records modified/added today in one database and add those to another database?
Is transfer of data between two databases possible?
View Replies
View Related
How i can know the data tranfer rate for particulat directory on server using ASP?
View Replies
View Related
Any ideas on how I can set some data in 1.asp, then have 1.asp do a server.transfer (or .execute, come to that) to 2.asp, and have 2.asp access the original data?
I'm aware that the Session object fits the bill but want to avoid using this if I can. Having said that, the nature of the data is very much per-user so things like the application object are definitely inappropriate.
Another way I can do this is redirect/querystring, but the additional roundtrip here is not attractive.
Any other (sensible) methods anyone can think of?
View Replies
View Related
I need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.
View Replies
View Related
Our asp programs seem to have different behaviors when users use IE and firefox. One of most annoying things is the data disappearing problem in IE but not in firefox.(Note: Sometimes a search program can run much faster in Firefox than in IE, don't know why)
For example, I have an internal user interface which they can do different product data
entry, the program will use Server.Transfer to different asp program for data entry.
Page1---UserInterface.asp
Select Case Request("Product")
Case "Sel"
Server.transfer("/Virtualdir1/test1.asp ")
Server.Transfer("/Virtualdir2/Test2.asp")
Case "Bear"
Server.Transfer("/Virtualdir3/test3.asp")
Case "IMED"
Server.Transfer("test4.asp")
Case "AC"
Server.Transfer("/Virtualdir4/test5.asp")
Case Else
End Select
When user finished data entry on test1.asp(second page, the web address will still show UserInterface.asp page as you know), click continue, on the third page if they found something typed wrong, if they click back button in the broswer, all data on the second page is gone. This only occurrs in IE, Firefox is fine.
It's very annoying, how can I fix it, if not, is there any other way?
View Replies
View Related
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp ....
View Replies
View Related
I'm trying to add logging to my web application, but I found a strange problem. Whenever I execute a Server.Redirect(Page1.asp) I can use the request.ServerVariables("SCRIPT_NAME") to get the current page name. However, if I use Server.Transfer(Page1.asp), the value of the server variable equals the refering page (In this case default.asp). How do I get the value of the working page regardless of the transfer method.
View Replies
View Related
I tried using the following statements to transfer to html and asp page but i could not
response.redirect("&results('Url')&")
or
Server.Transfer(results("Url"))
pls tell me how can i transfer to html and asp page that i get its url from database...
View Replies
View Related
I'm currently writing an asp page . There are many variables inside i want
to transfer to another asp pages to use them. They are just normal variables
calculated in this page (not variables received with http query ), therefore i dont
know how to receive and use them in a new asp page.
View Replies
View Related
---------------------------------------------
The Execute method allows you to call another ASP page from inside an ASP page. When the called ASP page completes its tasks, you are then returned to the calling ASP page. The overall effect is very similar to a function or subroutine call. Any text or output from the called ASP page will be displayed on the calling ASP page. The Execute method is a more useful alternative to using server-side includes.
In contrast, the Transfer method allows you to transfer from one ASP page to another without returning to the calling ASP page.
There is one mandatory argument.
---------------------------------------------
Fair enough does what I need it to. However, I've run into a glitch. I understand the point about it being like calling a sub which means anything set within the executed page will be considered local and so anything set within it won't work in the calling page. What I don't understand is why the executed page can't read objects which have been set in the calling page before the execute???
View Replies
View Related
I am using:
Response.ContentType = "application/msword"
Response.AddHeader "Content-Disposition",
"attachment;filename=Letter.doc"
to download my asp page to the client. The download process works great but when I open the .doc file it is missing the image included within the html <img> tag of the .asp page. How do I get the image to come down with the text?
View Replies
View Related
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
View Replies
View Related
Any idea what is causing this error? 006~ASP
0230~Server.Transfer Error~The call to Server.Transfer
failed while loading the page.
Just read about benefits of Server.Transfer over
Response.Redirect, replaced, and getting the error.
View Replies
View Related
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
Is it possible to write out the contents of a database into an exel-type
spreadsheet within an asp page?
View Replies
View Related
I'm trying to use Activer Server Pages (ASP) to get Data from SQL database to Excel. Do you need to have any ActiveX installed to achieve this and has anyone has experience in doing this?
View Replies
View Related
is there anyway to extract the data out of an asp table and write it into a seperate database that can be read by access or excel?
View Replies
View Related
I have two questions on exporting data to Excel using ASP (w/o converting
formatted excel file into web page and then plug in the dynamic data):
1. Can we export data into different sheets at Excel?
2. Can we do graph at export?
View Replies
View Related
I know the basic way of doing this when you have a static set of
spreadsheets but I need to be able to process different spreadsheets
every day. These spreadsheets are sent to us by an outside auditing
firm without named ranges. They have a consistent format. Is there a
way to read a specific set of cells without having a named range? Or
is there a way to name a range with ASP? I am open to any options
here. Going through and creating named ranges is the only thing that
wont work sicnce it would take more work than processing the files by
hand.
View Replies
View Related
Need your help in uploading excel data to a table in oracle db.We cannot install any server component so pls give some suggestions.
View Replies
View Related
I currently have an excel flat database, it contains a computerName and it has a list of parts associated with it next to the cell value of computerName.There values that are offsetted to the right are the parts associated with the computer name. I was wondering through ASP could i have a dropdown of the computerName, when clicking submit it will find the offsetted values to the right.
View Replies
View Related
i want to import data from excel and save it in sql server data base.my problem is how open excel file and read it cols by cols or rows by rows.
View Replies
View Related
How do i insert data into an Excel Sheet, Along with the provider to be used.
View Replies
View Related
I try to find the best small exemple to display data from excel to asp (connection & code). But only asp.net exemples in microsoft.com.
View Replies
View Related
I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help.
Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using:
SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable
But I'm not sure that is the right approach.
View Replies
View Related
I retrieve data from the database and display on ASP, then I export these data to a file, like Excel (the best) or text file. Is it possible? I think it is possible, but how can I do that?
View Replies
View Related
