Upload excel (multiple sheets) data into sql server

microsoft.public.inetserver.asp.general

16 Jul 2006 12:47 PM

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.

17 Jul 2006 3:23 PM

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

Show quote

"Pk" <p.ksi***@gmail.com> wrote in message
news:1153054045.080717.18150@h48g2000cwc.googlegroups.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.
>