Upload excel (multiple sheets) data into sql server

[Pk]

Hi,

I have an data in multiple excel worksheet which i wan to upload into
sql server through asp code.

Please help me how can i use
server.createobject("excel.application")

help me its urgent with code

Thank you very much in advance.

 

[Ray Costanzo [MVP]]

Automation of Office objects on your server isn't very advised. How about
creating a DTS package to import the data? You can use an ODBC connection
to extract data from Excel.

Ray at work