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.
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 pleaseThanks |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-04 : 00:11:14
|
there are multiple options1. Export Import wizard2. OPENROWSET3. BULK INSERT------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
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/ |
|
|
|
|
|