I have an Excel file with 20 columns.
In my db I have 12 columns.
Some of the columns in the Excel file I would like to import into my db and add to the fields I already have there.
I’ve never done this before and have no idea how to do this through phpmyadmin.
Should I add and delete columns in the Excel file, so it looks just like my db fileds and then export it and then import it to MySQL?
And how do I tell my db where to add the stuff?
Or how is this process done? Anyone?
I to will need to do this in the next couple of days so look forward to see if this is indeed possible.
Export Excel’s native format (.xls) to CSV (.csv). CSV is a plain-text file that can usually be read by anything. Excel is really annoying when exporting. Always say “Yes” and “OK” to whatever it is asking you (Are you really sure you really want to export to CSV?!!)
I don’t know if phpMyAdmin will import CSV but it might as long as the columns are identical to the table. You might be better served writing a quick PHP script that does the import for you.
I finally made it myself, just the way you described. But I had to fill in the last column with data (which was empty in my Excel). Then I imported it into a new table.
I worked with it and then made an INSERT INTO the correct table.