Excel sheet in ASP

Excel to Database

[deepali2005]

I want to transfer my excel sheet data to the MSSQL database using ASP. How I can do this?

[emsaw]

You should be able reverse the logic to move data from your Excel worksheet to your database.

How To Transfer Data from ADO Data Source to Excel with ADO [support.microsoft.com]

HTH,
-Mark

[aspdaddy]

Much easier way - Do it using DTS, save the package and call it from ASP:

Set dts = Server.CreateObject("DTS.Package")
dts.LoadFromSQLServer "<IP Address>", "<User>", "<Pass>", FLAGS,"<PackageName>"
dts.Execute

If you want you can even create the dts programatically in ASP but its much easier in SQL Server with the Wizard!

HTH