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 |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2008-11-16 : 18:57:20
|
| I am new to SQL and cannot figure out how to import data from excel or access. Can anyone help me? |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-11-16 : 19:08:18
|
| Which version ?for 2000 use DTS Wizard, 2005 and 2008 use SSIS |
 |
|
|
jcb267
Constraint Violating Yak Guru
291 Posts |
Posted - 2008-11-16 : 19:49:07
|
Sorry, forgot the version . I am using 2005.....quote:
Originally posted by afrika
Which version ?for 2000 use DTS Wizard, 2005 and 2008 use SSIS
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-16 : 23:07:54
|
| You can also use OPENROWSET if its for adhoc accesshttp://www.databasejournal.com/features/mssql/article.php/3584751/OPENROWSET-function-in-SQL-Server-2005.htm |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-17 : 01:43:27
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Importing Data