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.

All Forums  Other Forums  SQL Server 6.5 \ SQL Server 7.0  table update

Author  Topic  sibtain Starting Member 2 Posts Posted - 2009-09-23 : 10:29:30 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 manager 2) do i use the "views" or the "diagrams" and how do i use them, i wish to update the tables permanently. regards