Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Load Parent and child table. Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 7:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 9:11 AM
Points: 227, Visits: 565
Hi,
Please help me on below scenario.

My requirement is load two tables from single excel. I am having a parent tbl and child tbl data in excel.It is my source.

My target is sqlserver. two tables. I need to break data and load into two tables.

My sqlserver tables structure is attached with this post.

Can anybody please suggest d solution.


Thanks
Abhas.





  Post Attachments 
tblParent.docx (19 views, 14.71 KB)
Post #1407820
Posted Wednesday, January 16, 2013 9:33 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 2:16 AM
Points: 27, Visits: 267
Provide that Excel sheet format.It will be helpful to get a better idea.
Post #1408134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse