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.
| Author |
Topic |
|
ragh
Starting Member
34 Posts |
 Posted - 2004-03-11 : 00:26:19
|
| Hi guys,I have a problem and i think it can be done very nicely in SQL Server itself instead of using VC++.The Scenario:I get some text files(XXXXfd.txt) where XXXX=Areaname and fd = Fixed Deposits - Naming convention used.Now i put these files into a folder in C:\FilesArrived.Then when i run the program it will convert each line in this file into a row in tableXXX.Now i want this to be made in SQL Server, i think a store proc can make this operation.can u guys help me with a code, pleaseethen text file format will be as follows:---All i want is to fectch each line from a textfile from specified folder and put it in a table, if the same details exists then overwrite with newly arrived textfile or else leave it as it is.---This is the file i get in filexxx.txt format" 1010 ";"ABCDEF";"FD ";"AAAAA ";"120350 ";"12/11/1999";"RIRD ";" 1670600";"1050";" 1935200";"12/11/2002";" 2279900";"21/04/2001";**just copy and paste it in notepad..** ** The semi-colon represents Seperator**I hope u guys will help me !thanks in Adv, and warm regardsRagh |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-11 : 00:27:02
|
| Please do not cross post, once is enough:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33270 |
 |
|
|
|
|
|
Text 2 DB