I need to read a text file and then insert into a SQL server.
The text file is not in standard format as below.
ABC, 12345,
BBB,9988, PP
ABC, 556699,
CCC.8899,UU
It should be format like below:
ABC, 12345,BBB,9988, PP
ABC, 556699,CCC.8899,UU
All row is starting "ABC"
How to read this text file?
Go to the complete details ...