kamrag
September 28th, 2006, 02:20 AM
I have a web site in which any user(client) can upload the excel file.
The user is going to select file from his machine.
When the user clicks on upload the page(asp page) is posted back.
By using request.binaryread i will get all the contents of the page(asp) including the excel file data contents.
But i am not able to convert it into readable format.
My main purpose is that i want the Excel data in the recordset.
I have the code to create the recordset when the file resides on the server.
And to do that i will have to upload that file on the server and then read it.
And after reading the file delete the file from the server. But that is not the solution.
By using request.binaryread i am able to read the file by converting it to string. But the same is not working for excel file.
Please Help
Raghav
The user is going to select file from his machine.
When the user clicks on upload the page(asp page) is posted back.
By using request.binaryread i will get all the contents of the page(asp) including the excel file data contents.
But i am not able to convert it into readable format.
My main purpose is that i want the Excel data in the recordset.
I have the code to create the recordset when the file resides on the server.
And to do that i will have to upload that file on the server and then read it.
And after reading the file delete the file from the server. But that is not the solution.
By using request.binaryread i am able to read the file by converting it to string. But the same is not working for excel file.
Please Help
Raghav