Open File Read in columns and derive CREATE TABLE syntax While(Reading in dbf file) Optimise column length print OUT data into a text file Load data into database using LOAD INFILE syntax