When I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
I have a website set up that can pull data from Access database tables and display them on the webpage depending on users' selection. Is it possible to have ASP open up Microsoft Excel and dump the data into it, plot graphs, calculate averages, etc.?
Can anyone help with this? Here is the code I am using. The problem is, where it checks if a file exists, it always goes to else. Even if the file is there, it won't open the file, goes straight to else part of statement.
<% If Session("strLogID") = "" Then Response.Redirect("http://website/pages/login.asp")
I am creating a webpage and have a form where a visitor will choose a day, month, and year. I want to pass the data from the form into an asp page which will process it and put it into a string and open the excel file requested. The excel file to open will depend on the day, month, and year chosen in the form.
is it possible to open word or excel from an asp page in the client side having word or excel installed only on the server side?if possible, can u post an example ?
i'm trying to have excel open up a webpage which basically contains a table.
in excel 2000 if i specify content type text/csv this works by displaying an open/save dialog box and clicking open, launches excel and displays data as a table (desired result ) however in machines with excel 2002+ excel simply displays the html code.
trying to specify application/excel opens an excel plug-in inside the browser which poses a problem becouse the excel has links to pdf file that obscure the plug-in.
I have the following code at the top of my page. Is there a way to force Excel to open the spreadsheet? Presently, it opens within the browser window. I know it can be saved etc., but I would rather have Excel receive the data.
I've noticed that Internet Explorer adds a number in square brackets to files downloaded from the internet and opened directly (i.e. by clicking 'Open' and not 'Save'). This creates a big problem with downloading Excel spreadsheets as square brackets are not a valid filename character inside Excel worksheet name.
When I click open, it opens the excel sheet with the sheet name as .xls[Sheet and the excel filename as Sheet[1].xls.
Then we get the following error....
While renaming a sheet or chart, you entered an invalid name. Try one of the following:
- Make sure the name you entered does not exceed 31 characters. - Make sure the name does not contain any of the following characters: : / ? * [ or ] - Make sure you did not leave the name blank.
I want to place a Excel workbook on the web server and create a URL link to it and when the user clicks on it to the URL/vbscript behind it must launch Excel on the client and open the URL linked Excel workbook automatically.
Can you please share the code HTMl & VB script snippet that can do this.
i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
I'm using ASP to pull info from a database and open it in Word. Everything works fine but I want to specify the paper size to be Legal. Is this possible or am I stuck with Letter size?
this should be an easy one. I have a script which I use to add a new record to a database. Simple enough. But I have always used this string in opening up a database for just such a purpose: "SELECT * from images" Ok, I obviously don't want to select all every time I want to add record, so how would I just get access to that table without opening all of the records? Would it be - "SELECT images
I try to use as much functions as possible. So I have written a function to open a database and retreave the information from a specified field but it don't want to work. This is the function I use Code:
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt) DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
how to open or do a connection to open switchboard in the Acccess database? Really Really need help from you who knows the code to open the switchboard in access database using asp. or Is there a way to link switchboard form to the asp page so that when i click on a link , it will open up the switchboard form (lets say the form's name is called "Contact") from the Access Database ?
Basically everytime I need a page to access a database I will create a connection object, and then at the end of the page I will close the connection object.
Would it be more sensible to create all the connections to the database that a user will need when they first visit the site, and then close these connections once they leave the site. (Using something to do with Start Session and End Session).
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
I have 3 colums in an excel sheet (Serial No, Name, Mobile no), I want to put all the data in the excel sheet into the database which also has 3 colums (Serial No, Name, Mobile no) with a single click of a button using ASP. Can someone code me this?
I have included both the access database and the excel file within the attachment.
I have 3 colums in an excel sheet (Serial No, Name, Mobile no), I want to put all the data in the excel sheet into the database which also has 3 colums (Serial No, Name, Mobile no) with a single click of a button using ASP.
What i want to do is, I have an excel speadsheet that scans items and then fills in other fields (if that makes sense), what i want to know is I want to insert that info from the spreadsheet into a database used on a web site, line by line would be fine, i can do the insert bits fine, and the loops but, first is it possible and how do i link to the spreadsheet and get the info?
I have an application where I have to import data from excel to SQL Server using ASP. If someone can please give me some piece of code it would be of great help to me as I am new to ASP.