I am attempting to import a FIX (Financial Information exchange ) file into an access database using the import wizard but this does not work because the wizard doesn't differentiate what is at the the start of the file and what is at the end of the file. I currently save the Fix file as a text file as access doesn't understand what a fix file and try and import this. For background information is basically a text file with varying amounts of data per line but has a start and ending for each line.Sample excerpt from file below : 8=FIX.4.1,9=0081,35=A,98=0,108=60,95=11,96=easylogging,52=20051202-06:37:45,49=UknWrkSta,56=,34=1,10=077, 8=FIX.4.1,9=0216,35=EASYMSG,5156=0,5164=0,5163=0.00,5142=System,5060=,5063=06:37:45,5062=20051202,5112=06:37:45,5061=SYSTEM,5020=STARTUP,5021=,5141=2.0,5075=TCL23,5140=UnsetUser,5058=369582,52=20051202-06:37:45,49=UknWrkSta,56=,34=2,10=151, You will note the start of each line is always with 8=FIX.4.1, and the end is always 10= ( a value that changes constantly. The length of each line may vary dependant on the amount of data contained within each line. So in summary i need to Open the File in this example the file is called 2902MyOr.Fix and loop through where each line starts with 8= and populate each row with the data - leaving fields blank if their is no data in that field for that row. The row only ends when the last piece of data is identified with the value 10= and then everything is inserted into the row before starting on the next piece of data to interpret. Any help on the import procedure for this would be appreciated.