Forum Moderators: coopster

Message Too Old, No Replies

Import CSV File Into Database Table

if not phpmyadmin then what?

         

madcat

5:19 pm on Jan 10, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Are there any programs like phpmyadmin, that allow you to import CSV files without first converting them into mysql statements? mysql front?

I've created the table and fields, and it should be easy enough to import the data into its respective columns.

Thanks for any help!

jatar_k

5:37 pm on Jan 10, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



you could write a script to do it, maybe using fgetcsv() [php.net].

andreasfriedrich

1:42 am on Jan 11, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



If you are using MySQL have a look at LOAD DATA INFILE [mysql.com].