Hi guys i hope you can help i am concidering a move from a delimted txt file to database. as i am very new to databases and not much less newer to vb i am looking for an example of code that does in light form what i am trying to do then i can google and adapt it/ learn how it all works.

i have the following txt file with 100 od lines example as follows

jack%toyota%corolla%red

i am allready able to do all the slpitting " "%" as i allready use the txt file in a current project its just i am thinking ahead as i think the txt file will eventually be out dated and db would be much more future proof. so examples of code to write to/ read from and update records suited to the string above would be a real help thanks.