timmah1 Posted January 16, 2008 Share Posted January 16, 2008 What is the best way to import an excel worksheet into a MySQL database? I save it as Tab Delimited, I get errors, I save it as a Comma delimited, I get errors. I did run the query once, but the only thing that was entered was the id (because it's auto increment) How do I get this database of 349 items into the database without manually typing each one in? Thanks in advance Link to comment https://forums.phpfreaks.com/topic/86257-excel-to-mysql/ Share on other sites More sharing options...
aztec Posted January 16, 2008 Share Posted January 16, 2008 Hello I used a program called SQLyog which will allow you to inport a CVS file. Sorry I cannot be more specific but it was some time ago. I know it worked with an Excel sheet I needed to get into mysql, you can download it for free at some sites. I also remember that when I searched there were other programs that will do what you require. Regards Link to comment https://forums.phpfreaks.com/topic/86257-excel-to-mysql/#findComment-440856 Share on other sites More sharing options...
toplay Posted January 16, 2008 Share Posted January 16, 2008 SQLyog can do it or use: http://dev.mysql.com/doc/refman/5.0/en/load-data.html Link to comment https://forums.phpfreaks.com/topic/86257-excel-to-mysql/#findComment-440900 Share on other sites More sharing options...
kts Posted January 16, 2008 Share Posted January 16, 2008 I usually save it to a csv file and import Link to comment https://forums.phpfreaks.com/topic/86257-excel-to-mysql/#findComment-441013 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.