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: Tuesday, February 24, 2015 9:46 PM
Points: 237, Visits: 581
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: Thursday, February 5, 2015 8:34 AM
Points: 27, Visits: 269
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