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 2008 Forums
 Transact-SQL (2008)
 Update 4 fieldnames in one table with records...

Author  Topic 

simflex
Constraint Violating Yak Guru

327 Posts

Posted - 2010-01-12 : 16:42:39
hello again, dearest experts.

I am trying to update 4 fieldnames on our SQL Server 2008 database table with records from 4 columns from an Excel Sheet.

Is there an easier way to do this?

I am only interested in those 4 fieldnames even though there are several more fieldnames.

Thanks a lot for your assistance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-12 : 17:22:33
You can use SSIS for this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

simflex
Constraint Violating Yak Guru

327 Posts

Posted - 2010-01-12 : 19:37:02
Ok, I will research how to use it.

I have never used it before.

thanks alot
Go to Top of Page
   

- Advertisement -