Hi,
I would appreciate if anyone can help me in this regard.
1. My client uploads excel file through web, this excel has only 4
columns .
2. Now i want to insert the data from Excel to Sql Server how do i do
that? i have only one solution that i can read excel file using VB.NET
and then Start firing Insert command as many rows i have. This solution
is very bad when i have 10,000 record , my program takes his own sweet
time of 15 to 20 min. I need programmable solution.
Regards
Gopal

Hello gopal.panda (AT) gmail (DOT) com,

So you want to import an excel file ad do some updates?

You can use the Excel Source Adapter and use the OLE DB Transform to do the
UPDATEs. Will this work for you? If not then can you explain more about
what you do want?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com