Welcome to WebmasterWorld Guest from 23.22.250.113

Forum Moderators: coopster & jatar k

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 jatar_k is a WebmasterWorld Top Contributor of All Time 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].
 

Featured Threads

Hot Threads This Week

Hot Threads This Month