dbTalk Databases Forums  

Uplaoding excel file into SQL database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Uplaoding excel file into SQL database in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sangeetha saravanan
 
Posts: n/a

Default Uplaoding excel file into SQL database - 11-25-2004 , 04:00 AM







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!

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Uplaoding excel file into SQL database - 11-25-2004 , 10:41 AM






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

Quote:
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!



Reply With Quote
  #3  
Old   
sangeetha saravanan
 
Posts: n/a

Default Re: Uplaoding excel file into SQL database - 11-25-2004 , 10:00 PM



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!

Reply With Quote
  #4  
Old   
Darren Green
 
Posts: n/a

Default Re: Uplaoding excel file into SQL database - 11-26-2004 , 03:21 AM



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

Quote:
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!



Reply With Quote
  #5  
Old   
X. Zhang
 
Posts: n/a

Default RE: Uplaoding excel file into SQL database - 11-26-2004 , 11:19 AM



try to use Microsoft DTSPackage object library

"sangeetha saravanan" wrote:

Quote:
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!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.