Spliting text line data into tables.

[cherosoullis]

I have a file with multible lines. I managed to import this file into VB.NET. Now I want to split the file according to the data of each line. e.g. The lines could start with numpers from 1 to 10 (repeated in many lines). I will greate 10 tables (to store lines starting with relevant number) and I want to enter.
A commant that will say that if line starts from 1 put in 1st table, if line starts from 2 put in 2nd table etc.
Can you help me pls.

 

[boblarson]

First of all, it sounds a little fishy to be creating 10 tables based on the number. It would be nice to get a little more information as to what that text file contains so that we can offer some suggestions as to what might be a better way to handle this. I am suspicious that you might not be normalizing your data, which will likely cause you problems later.

 

[cherosoullis]

I made that spliting on access with (First part: Mid([Description],1,1)) but I want to take advantage of the funcionality of .net