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 |
|
shaw
Starting Member
15 Posts |
 Posted - 2007-05-03 : 15:58:23
|
| hi there,i am using MS SQL 2005. i have an xxx.xls file (has 3 columns in one worksheet) that needs to be uploaded as a table with 3 fields (corresponding to the columns in my excel sheet) into my database. does anybody know how to do this?thanks, |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-03 : 16:33:29
|
| Use import data wizard in SSMS. |
 |
|
|
shaw
Starting Member
15 Posts |
Posted - 2007-05-03 : 16:45:36
|
| in my server management studio toolbar, i have searched for and export/import wizard, i ended up with nothing.would you please tell where that specifically is? |
|
|
|
jshepler
Yak Posting Veteran
60 Posts |
Posted - 2007-05-04 : 10:04:57
|
| right-click the database, select "Tasks", select "Import Data"./jeff |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
upload excel as a table in sql 2005