Its been almost 2 weeks that im trying to figure this out and next week is already the deadline. I hope someone can help me with this.
I am developing a system whereby the user will upload a text file via visual studio(using the fileupload control) and the data in the file will be inserted in SQL table. However the txt file are of fixed length therefore i included a schema file in order for the data to be inserted in the right column.
And then i did more and more research and i find that i need to create a stored procedure too and so i did. And the problem now is that my SQL select statement all can work in SQL but i do not know how to put all this data together and do not know any coding whereby i can insert the data from the file into SQL table using VB.

below are the schama.ini the text file and the stored procedure coding. can anyone help??? thnkx!

code.txt
MORNING CONTAINER AIR AV
HALEX FRIENGT AH
ARTACTIC AK
ARTATIC BN
AMARA SUITE HOTEL AC
ARMANY SWEDEN AMBASSY AP
CARGO FRIEGHT HOLS AJ
AREA OF DEFENCE DEF AT
CONTAINER SHIPPER AW
WHITE ROSE AMBASSY AZ
ALLIES DNA SWE AI


schema.ini
[code.TXT]
ColNameHeader = False
CharacterSet = ANSI
Format = FixedLength
Col1=FullName Text width 23
Col2=OpCode Text Width 2

stored procedure
create procedure spUploadFile
@fullname varchar(23),
@opCode char(2)
AS
Insert Operator(FullName, OpCode)
values(@fullname, @opcode)
return