Load data

jortiz · #1 (**permalink**) 05-21-04, 11:32

Hello !

Is there a way to load data from a flat file using a kind of free utility, I tried with the sql admin, but I dont know how and i don't know the format of the flat file.

Thanks !

guizai · #2 (**permalink**) 05-21-04, 12:30

This is a GUI software that allows you to access your mysql tables and what not. It also has import/export capabilities.

http://www.mysqlfront.de

I hope this helps and was what you are looking for.

guelphdad · #3 (**permalink**) 05-21-04, 12:30

you can use LOAD DATA INFILE see the manual for details.
you of course will have to figure out the columns before loading any flat file into a database.