we have web users that have requested the web application access an existing
excel spreadsheet directly.
Users have an excle spreadsheet with complex functions, macros, formatting
etc. They have data in the database that is accessed via a web applciation.
They would like to use the web app to get the data they want on screen and
then click a button to get that data and put it into specifc cells in the
spreadsheet. is this possible?
Does anyone know how to save an export excel file to the server automatically without any prompting and opening of the excel file?
Because I'm doing archiving, I need to let the user click on the archive button and the exported excel file will be saved directly to the server without opening the file.
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
Basically, I want to have an asp page that has a button where when you click on it, it opens up a file open dialog box where you can search for any excel file you want to import. Then, once a file is selected, I want to read all the contents of the excel file (from column A) to display into a listbox on the screen (so that each individual row from excel file would be a separate item in the listbox). Also, this data would have to be inserted accordingly into an access database .....
View Replies View RelatedI currently have my database set up so that when a user uploads a file, it writes it in binary in the database. I know the benefits of having a separate file server and storing the path, but unfortunately, I can not do it that way.
I know how to include the file in, lets say, a hyperlink so that any user can click on the file to view it. But, I would like to know how to include the file (mainly pictures) directly into the page as an <img src> Any suggestions?
P.S.
Once the information is in the database, these are the commands I use to output the file to a hyperlink. The file that this code is in is "file.asp?Id=" Where the Id is taken from the URL and used to obtain the correct file. I left out all the connection/cmd strings intentionally just show I could show the relevant information:
Response.AddHeader "Content-Disposition", "filename=" & _
rs("FileName")
Response.ContentType = rs("ContentType")
Response.BinaryWrite RS("FileData")
I have registered a domain, if i want to check my mail i had provision to go to there web server mail page from there i could login and see my emails,
i have a created home page in ASP there i had login page with username and password,
if i enter the username and password it should straight away take me to the email folder(accessing from my home page rather than going to the their web server login page)....
how to print the content of a multiline textbox without taking the content to some other "printer friendly" page. I just wanna send whatevers in the textbox directly to the printer.
View Replies View RelatedI have an Excel database of Names and Email addresses that I have to use to send a monthly automated newsletter to. The thing is that my application uses Access, and I am not sure how I can avoid having to maintain two seperate databases. I have to take the Excel DB and convert it to Access, every time there is an update. Then change field names, and db structure for use in my app.
Do any of you know how I can have it either automated, or made a little less time consuming, and simple to maintain?
With ASP I register in DB Access rows of one file excel; this procedure works but problem: Access record double rows of file excel.
You can exclude from registration double rows ?
I attach the file excel record to access.
I register with this logic:
1) all rows;
2) where rows no data register date of today;
3) if same row with a date and the other undated eliminate row undate.
Register rows excel file number: 1, 4, 6, 7, 8, 9, 10, 11, 12, 13, 14
Discard rows 2, 3 and 5
In the field date rows 6, 7, 8, 9, 10, 11, 12, 13, 14 record date of today.
Code:
I have the page "content.asp" and it is called from the "menu.asp" page.
Two page are on diffenent servers and on different Databases.
Users who request the content.asp page are authenticated when they enter the
"menu.asp" page.
So, if another authentication is required when users enter "conent.asp", it
is redundent, I think.
Finally, I want to reject users requests for content.asp if the page
"contnet.asp" is requested directly from URL.
Are there ways if the page content.asp is called from URL or the <a> tag in
the menu.asp?
i have used this code for importing Excel files to the database but always get this error: >> Syntax error in FROM Clause: Code:
View Replies View RelatedI am in the process of building a small Intranet application. Iam using ASP along with access backend on IIS 5.0.
Info will be sent from an HTML form, [an inventory report] various drop down lists, text boxes, etc.
This info from the form is then added to the mdb, but an administrator needs to pull the same form back to add further info to complete the form, [cookies?] and finally it gets exported to excel format and saved on the server. Also an admin page needs setting up so "admin" can confirm when some reports are completed and when others need completing, maybe this could be the way the first part of the form could be stored and pulled back from ? Could it all be done in MS office applications?
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.
how to convert excel contain japanese text to access format, and allow the japanese text converted to access allow to display in the web browser? Because when i try to display the text inside my browser, all the japanese text become ?
View Replies View RelatedI imported an excel data files with columns heading A, B, C, D, E, F in Access. However, in Access it shows up as reverse column order, F, E, D, C, B, A. Anybody knows why and what should I do to correct the order?
View Replies View RelatedDoes anyone know of a way to take the records of my database and have it downloaded to an excel worksheet with asp???
View Replies View RelatedI am trying to upload an excel file into MS access dB using ASP and its not working.
View Replies View RelatedI using ASPupload to upload the file to the sever but what asp code do i then use to import the data in to my table?
View Replies View RelatedCurrently I am having an ASP page to store data into access database, I would like to convert my database into microsoft excel format due to licensing problem, I never deal with excel databse in asp programming before, appreciated if some expert can show or guide me thru this.Tks a lot.
what are the code that I need to change in my asp code to link to excel file instead of access db.
Am tying to build a system where you can browse and upload files into a MS Access database.
View Replies View RelatedWhen somebody downloads my Setup Program from my Web-Site they are taken to a blank page first so that I can use this to record the download hits, then the download window comes up.
How can it be done so that when somebody clicks on the download link, the download window comes up, but by this stage I have recorded this as a download hit,without having to display a blank page on the browser first?
I'm keen to learn how to do some simple asp script so that I can access my customer database over the internet from various locations.
I want to know how to write the appropriate script into an html form (I use MS Frontpage as an editor) so that when I log in to my site I will be able to see and edit this database directly on the net without having to download the file for editing, then upload it again until next time.I understand that I will have to save my database as a MS Access file (*.mdb) because this format will work better with asp commands.
If you know of an online Dummies Guide to ASP please let me have the link so I can learn some of the basics without having to bore you with working through all that.
Anyone know how to read excel file with ASP and stored it in database?
View Replies View Relatedhow to export ms-access tables information to excel sheet using ASP....
View Replies View RelatedImporting EXCEL worksheet into existing ACCESS tables is possible.
Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.
How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us.
i have a sample code which works only exporting to single worksheet. but i need to export data to multiple worksheets. Code:
Sorry if this is the wrong place but does anyone have a script which will export data from an access database to an excel spreadsheet allow a user to edit and then import the edited excel spreadsheet into the db?
View Replies View RelatedIn order to test some pages of mine, is possible to directly hard-code a request passing some parameters in a post method to an asp page?
View Replies View RelatedHow to export data from ms-access database to excel worksheet. mainly i need to export data to multiple worksheets. it is very urgent to us.
View Replies View RelatedI need to provide a way to download a software and its corresponding
manual from a web page.
So far I have done the sign in page where people give their data. I
will then give access to a page with a link allowing to download the
required file(s).
My worry is how to avoid that somebody grabs the URL of the file and
send it to another for downloading directly from the server. What can
I do to avoid this ?
Theres a script that bypasses ODBC and connects directly to .mdb database for asp scripts , is anyone familiar with this? I dont even know if its a .asp script.
View Replies View RelatedI'm looking for an activex com that will be given an existing url and turn it into pdf binary stream (no files on the server) either that or turn into a tiff image.
I would like something that has a small footprint meaning no impersonation, no visual screens, just pure sdk ...
I have created a script that parses and excel file and inserts the data in an Access table. The script works perfectly fine, however I also need to extract a column comments via my script.Column comment is like a tool tip for any given column and therefore it occurs only on mouse hover, not in the actual column data.
View Replies View Related