Welcome to WebmasterWorld Guest from 184.73.3.107

Forum Moderators: coopster & jatar k

Import CSV File Into Database Table

if not phpmyadmin then what?

   
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!

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].
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

My Threads

Hot Threads This Week

Hot Threads This Month