November 22, 2005 at 6:51 am
Hi,
I need to develop a web page where the user can put in some information like email address, notes, etc, then click a button to upload an excel spreadsheet into the database. The user will have the spreadsheet in a pre-determined folder with a pre-determined name. The data in the sheet needs to be put into the database along with information like userid, username etc which is gleaned from cookies/hidden fields etc on the page. I am stumped because the excel sheet will be on the client's machine, not the webserver. I am using ASP for the web pages and SQL Server 2000 for the database.
Any help in pointing me in the right direction will be appreciated.
Thanks,
VP
November 23, 2005 at 7:05 am
You will need to upload the Excel file to the server before processing it. Web browser security will most likely prevent you from accessing a file on the client thru Javascript or other client-side scripting. Use an <input type="file" ...> control on your web page to let the user browse for the Excel file. Search the web for info on uploading files via ASP, tons of info out there. An applet like Persits AspUpload makes this easy. Once you have the file uploaded, write it to a temp directory on the server, process it, then just delete it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply