Hi,

How to upload data from an excel sheet into SQL database? We are using
ASP.Net Webmatrix and C# as backend.

Thanks in advance.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Try using the Import/Export Wizard, available directly from the Start menu
or from within Enterprise Manager.


--
Darren Green
http://www.sqldts.com

"sangeetha saravanan" <sangeetha.saravanan (AT) wipro (DOT) com> wrote

Hi,

I asked for asp.net code to upload data into SQL server and not through
SQL Enterprise Manager.

Thanks.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you ask in the DTS newsgroup I think it is reasonable to expect a DTS
based response. I also don't read your response as specifically asking for a
ASP.net solution. I use C# ASP.net with SQL behind, and I use DTS for data
transfer, so I'm not sure what part of your detailed statement of
requirements said your couldn't use DTS

If you actually understand my response, and now that you clarify the context
a bit, carry on and use the Wizard to build a package and then call this
package via ASP.Net. You could build the entire package at run-time in
ASP.Net, but I suggest you still use the Wizard to start with and then use
Save As VB to get some VB code to help understand the object model. Then go
ahead and build the full package in C#.

--
Darren Green
http://www.sqldts.com

"sangeetha saravanan" <sangeetha.saravanan (AT) wipro (DOT) com> wrote

try to use Microsoft DTSPackage object library

"sangeetha saravanan" wrote: