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 |
|
sibtain
Starting Member
2 Posts |
 Posted - 2009-09-23 : 09:42:52
|
Hello guys,Please help me on the issue , i have configured a sql server 2000 on a server which consists of a table, i want to update a column from an excel file. what are the different ways i can do that. i mean i know the sql statements which can be used, what i want to know is 1)where do i go in the sql enterprise manager2) do i use the "views" or the "diagrams" and how do i use them, i wish to update the tables permanently.regards  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-24 : 02:53:49
|
| You can make use of import/export wizard (Right click on database-->All tasks-->Import/export)MadhivananFailing to plan is Planning to fail |
 |
|
|
Zim327
Yak Posting Veteran
62 Posts |
Posted - 2009-09-24 : 11:13:18
|
| I agree DTS (Data Transformation Service) is the way to go.The only caveat I would add is this:In my experience I found it much easier to simply import the excel spreadsheet as a separate table then use that to update your first table. Things always worked much better this way. At least for me...Just drop the table when you're done.(my 2 cents) |
|
|
|
|
|
|
how to update table