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
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 export and import

Author  Topic 

rum23
Yak Posting Veteran

77 Posts

Posted - 2009-04-01 : 12:50:48
I want to export 2 columns from an SQL Server 2005 table to an excel 2003 file. After some updates to field values in the excel file, I want to update (import back) those 2 fields from the excel file to the sql server table. How can this be done? Please help.

Thanks.

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-04-01 : 13:26:05
Why not update the table directly instead of all this?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-01 : 13:30:40
use export/import wizard or openrowset or linked server.

http://support.microsoft.com/kb/321686
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-02 : 05:05:23
Also refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -