I'm using phpMyAdmin - 2.8.0.3
I need to import a mailing list to my database. I can format however; it doesn't matter. CSV or TXT file. I can import it to start a new table or append an existing table; it doesn't matter.
I just need the format. Can't find instructions or documentation anywhere.
If this is too difficult, how hard would it be to write a php page that uses a comma delimited text file to import records?
This is a one time operation. Somebody please help.
Importing into phpMyAdmin
Moderator: General Moderators
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
phpMyAdmin has a wonderful array of import/export tools available. And they work well. Make sure your table is built before trying to import. Also, make sure your CSV file has the correct number of the fields and that it is formatted properly (like handling address data that has a comma in the value).