Import Excel data into sql server 2012

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 2012 Forums

SSIS and Import/Export (2012)

Import Excel data into sql server 2012

Author

Topic

jeeva_perumal
Starting Member

2 Posts

Posted - 2014-05-07 : 12:56:32

1.How to import only specific columns of excel into sql database using import wizard?
2.How to overcome the error of un-matched number of errors between the fields?

Thanks

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-05-07 : 13:11:45

This does not directly answer about the import wizard, but ,use powershell to import specific columns of Excel worksheets into SQL Server .follow this link http://www.sqlserver-dba.com/2013/01/sql-server-export-excel-data-to-sql-server-with-powershell.html , which gives you an example of how to import columns into SQL Server, giving you detailed control

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

jeeva_perumal
Starting Member

2 Posts

Posted - 2014-05-07 : 14:03:49

Any other way to do it , Please let me know

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources