Monday, March 04, 2013 9:16 AM
my text file (text.txt) contains header records (first row) and data records(remaining rows)
i want to seperate header records (header.txt) and data records(text.txt)
Tuesday, March 05, 2013 7:47 AMThis is not a SQL Server question, isn't it? I would use sed in the first place for such an task. And a simple splitting tool is also written in 5 minutes using .Net..
Tuesday, March 05, 2013 9:10 AM
this is not the sql.
you need manual work, just copy data from txt to Excel and split your columns there and copy paste as per your need.