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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.