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 |
|
tantcu
Yak Posting Veteran
58 Posts |
 Posted - 2012-08-10 : 14:46:25
|
| I'm having the spreadsheet in Excel and I need to import these data into SQL as a table. Is there anyone know how to do it? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-10 : 14:48:43
|
| There are a number of ways - listed briefly here: http://support.microsoft.com/kb/321686The simplest perhaps is to use the Import/Export Wizard that you can invoke by right-clicking on the database name in Object Explorer in SSMS and selecting Tasks->import/export |
 |
|
|
tantcu
Yak Posting Veteran
58 Posts |
Posted - 2012-08-10 : 15:02:03
|
| Thanks it helps a lot |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Import excel spreadsheet become table in SQL