Uploading an Excel to Database using ASP

anandham · February 23rd, 2005, 04:07 AM

Hi,

I have all my databases in form of Access. But the Client sends it in the form of Excel. I can manually import the contents from the Excel to the Access. I would like to automate this by giving a front end where in I select the Excel file and when I click the upload button the data gets uploaded into the Access table. Can anybody give me an idea how I can do it using ASP???

Thanks in advance.

Prem Anandh P.
Ambition Never comes to an End

Shibu · February 23rd, 2005, 04:29 AM

Hello Anantham
If this is the first time that you are dealing with ASP/Excel then you will be happy to hear that, we can use same ADODB connection set to access Excel files.

Connect it using following connection string

Code:

str_xl_datasource="Provider=Microsoft.Jet.OLEDB.4.0;" & _ 
                                                        "Data Source=" & server.MapPath(".") & "\excelfile.xls;"& _ 
                                                        "Extended Properties=""Excel 8.0;HDR=NO"""

After this you can easily retrieve the excel data by just giving the
query

Code:

"SELECT * FROM [sheet1$]"

Hope this will help you

Shibu Narayanan
Software Associates