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)
 Need help updating tables from .csv files

Author  Topic 

RandyHJ
Starting Member

5 Posts

Posted - 2009-10-14 : 14:53:50
I just have some basic skills in TSQL. I have successfully imported new data into tables using .csv files. Now I need to import data into already existing columns that updates values in those columns. I do not know how to do this. Can someone help me? Are there tutorials online I can view to see how to do this?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-14 : 15:34:44
OK so you have some basic skills in T-SQL.
So I think you don't need to find a tutorial to tell you that there is a statement called UPDATE and so on.
The best way for you to get help is as follows:
describe your table structure.
give some sample data.
give the wanted results.

And please read this:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -