Import excel to sql table - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Import excel to sql table

Author

Topic

anuraag205
Yak Posting Veteran

58 Posts

Posted - 2013-06-03 : 08:36:34

i have a huge table and want to import the excel sheet to it at the end of the table.

is it possible through import option????

any guidance please

Thanks

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-06-03 : 08:39:36

Yes you can..
http://www.rodolforodarte.com/2010/03/importing-data-into-sql-server-using-the-import-export-wizard/

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-04 : 00:11:14

there are multiple options
1. Export Import wizard
2. OPENROWSET
3. BULK INSERT

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-06-04 : 07:48:16

Another option is to export Excel to SQL Server using Powershell - some ideas on : http://www.sqlserver-dba.com/2013/01/sql-server-export-excel-data-to-sql-server-with-powershell.html

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

prett
Posting Yak Master

212 Posts

Posted - 2013-06-19 : 06:54:41

I have used "Import Wizard" to import the excel sheet. For step by step process, please check this post: http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources