I have many *.dat files. I want to insert selected columns from each file into database. How can I automate this process using c#,.net ,bcp utility and format files. Or does sql server have the ability to automate this process.
Also as you can see in the attachment it has some columns but it also has some columns after a lot of space which i could not get in the screenshot. Please help
also i just want the some of the columns like i dont want any value until Mname. I want values from the next column ex for last row i want
2775 in 1 column then 191 in 1 column then 4 in 1 column then 3 in 1 column and so on.
Just to elaborate 191 is test number and "4 " "3 " are responses. Thank you.