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, July 6, 2015 6:22 AM
Points: 251, Visits: 608
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, July 8, 2015 11:05 PM
Points: 28, Visits: 307
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