How do I do this? I know that the columns in the spreadsheet need to match the fields in the MySQL table, but what do I do to actually move the data across?
How do I do this? I know that the columns in the spreadsheet need to match the fields in the MySQL table, but what do I do to actually move the data across?
Export the excel file as CVS or TXT then import it using the LOAD command:
Code:LOAD DATA INFILE './dir/file.cvs' INTO TABLE table_name;
Cheers for that John :-)
If it's on the server then use an absolute path, ie: /var/www/public_html/myfile.txt and obviously upload it to that location.
You can also use the LOCAL keyword if you are using a client-side sql query tool.
The following page should help you out:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Social Networking Bookmarks