I have a text file. It has data as below. File size is 115 mb. All seperated by ":" will go in seperate column
I want to export to sql table. what will be fasttest way?
thanks in advance
:A1:398840:655008:398615:399058:654714:655322:null::Edward:Northumberland:Northumberland:NT95NE:NT95:Roads
:A1:399382:650067:399091:399661:649884:650231:null::Shielfield:Northumberland:Northumberland:NT95SE:NT95:Roads
:A1:398453:654118:397330:399045:651761:657053:null:BERWICK-UPON-TWEED:Elizabeth:Northumberland:Northumberland:NT95SE:NT95:Roads
:A1:418536:618396:417779:419456:615941:620369:null::Rennington:Northumberland:Northumberland:NU11NE:NU11:Roads
:A1:419519:615774:418536:420599:613188:618396:null::Denwick:Northumberland:Northumberland:NU11NE:NU11:Roads
:A1:420064:612335:419394:420595:611607:613188:null:ALNWICK:Alnwick:Northumberland:Northumberland:NU21SW:NU21:Roads
:A1:417126:621823:416 ...
Go to the complete details ...