«

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.

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

"Pk" <> wrote in message
news: ups.com...
> 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.
>