Update a Table from a text file by running a store procedure......
Posted on 2010-11-16
I have a table: TableTest in Mircosoft SQL Server that I would like to get updated on a regular basis when the Update.txt file get updated. The txt file reside on the SQL server
All the content of the txt file need to replace the content of the table once the text file get updated.
Should I write a store procedure for this and if so? How do I do this?
Text File: Update.Txt
V04510;5/28/2009;00729783;Q10070849I;9/29-30/07 RMB INV#22738;156;SHORT, JUDY
SELECT TOP 1000 [Vendor Number]