<div>
Yes,jonaska is right.<br />
<br />
If it is routine work then its good to be automated using SSIS packages. All relation are maintain in normal import export wizard also.
</div>


Yes,jonaska is right.

If it is routine work then its good to be automated using SSIS packages. All relation are maintain in normal import export wizard also.

<div>
<div class="content wysiwyg-content">
I have been sent an excel file that contains data from two tables. &nbsp;The execl file contains a tab for each table. &nbsp;One column in one of the tabs has the references to the other table. &nbsp;So I guess the original database has three tables. &nbsp;The third table being all the joins between the other two.<br />
<br />
Is there a way to import the excel file so that it creates both the tables but the &quot;third&quot; table with the joins?<br />
&nbsp; 
</div>
</div>


I have been sent an excel file that contains data from two tables.  The execl file contains a tab for each table.  One column in one of the tabs has the references to the other table.  So I guess the original database has three tables.  The third table being all the joins between the other two.

Is there a way to import the excel file so that it creates both the tables but the "third" table with the joins?
  

SQL Server import data from Excel

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.