Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Import .xlsx into SQL Server

Author  Topic 

pointer
Starting Member

2 Posts

Posted - 2015-05-21 : 07:22:13
Let say i have two .xls file

1. Employee.xls(empid, ename,salary,detno)

2.Department.xls(deptno,Dname,Dcity)

Need to import into 2 different table in Sql Server named 'Employee' and 'Department'. It should be done by using variable.

Is it possible to create table schema as of .xls file dynamically.

Please suggest.
   

- Advertisement -