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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to update SQL Table from Text File

Author  Topic 

sanjay1909
Starting Member

14 Posts

Posted - 2005-04-05 : 10:53:29
Can anyone tell me how to update records in a SQL Server table from Text File as Source

Regards
Sanjay Masawan
sanjaymasawan@yahoo.com

rfrancisco
Yak Posting Veteran

95 Posts

Posted - 2005-04-05 : 11:00:56
One option is to load the Text File into a temporary table.

If you don't want to load the Text File into a table, you can use OPENDATASOURCE, OPENQUERY or OPENROWSET.
Go to Top of Page

sanjay1909
Starting Member

14 Posts

Posted - 2005-04-05 : 23:57:25
I thanks for ur answer
I would appreciate if I could get it in more detail

Regards
Sanjay Masawan
sanjaymasawan@yahoo.com
Go to Top of Page
   

- Advertisement -