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 |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2012-07-11 : 06:12:32
|
| hii have Microsoft sql server management studio express 2005can i import data from MS EXCELthanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-07-11 : 07:09:58
|
| You can try using ssis.Right click on the database, tasks, import data.Might have issues with some data types so check it.I prefer to upload from excel by creatring insert statements and running them but it depends on the system==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-11 : 07:12:16
|
| If you don't have the Import/Export wizard, you may need to download a toolkit. See Bill Elicson's response in this thread: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
import data