kate_rose Posted June 11, 2008 Share Posted June 11, 2008 Hi, I am new to php & mysql. I am trying to develop a web based plant key. I need to convert my excel database with all the info in it to a mysql database. I have tried to find a converter online and there are a lot to choose from (kind of hard to sort through them all). All the ones I have looked at have limits on the number of columns that can be imported and my database is pretty big. Do I have to chop it into bits and put it back together in mysql? I definitely want to try the converter before I spend any $. Can anyone suggest a program and shortcut my search time. Freeware would be great if possible. Thanks, Kate Link to comment https://forums.phpfreaks.com/topic/109804-convert-excel-to-mysql-database-suggestion/ Share on other sites More sharing options...
fenway Posted June 12, 2008 Share Posted June 12, 2008 You can use a CSV file directly as a mysql table... see the CSV engine type. Link to comment https://forums.phpfreaks.com/topic/109804-convert-excel-to-mysql-database-suggestion/#findComment-564126 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.