phpMyAdmin Import data from file

chrisbutts · 04-22-2004, 11:22 AM

Hey Guys..........I am running phpMyAdmin to administer my MySQL datadase. I have an excel file full of data and I need to import it into my postnuke address book table. I saved the excel file as a .txt file and then import it using phpMyAdmin import tool. But I got the fields in the wrong place..........Can some advise what I need to do...Thank you

Chris

david_ross · 04-22-2004, 02:49 PM

If you go into the SQL window for the table you wish to import to then click on "Insert data from a textfile into table" you can enter the "Column names" in order that you want to import.