dansk Posted January 11, 2007 Share Posted January 11, 2007 hey everyone,i have some spread sheets and i want to convert them to mysql DBs, any good free programs for that?thanks Quote Link to comment https://forums.phpfreaks.com/topic/33712-excel-to-mysql-import/ Share on other sites More sharing options...
fenway Posted January 11, 2007 Share Posted January 11, 2007 Depends what you mean by convert -- you can easily import the values, but if you want anything fancy, I suppose you'll need to do some more work, and maybe there are such programs available. Quote Link to comment https://forums.phpfreaks.com/topic/33712-excel-to-mysql-import/#findComment-158602 Share on other sites More sharing options...
dansk Posted January 11, 2007 Author Share Posted January 11, 2007 just need to import the values into a table to create a db that's all Quote Link to comment https://forums.phpfreaks.com/topic/33712-excel-to-mysql-import/#findComment-158625 Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 Then LOAD DATA FROM INFILE with appropriate delimeters should do the trick. Quote Link to comment https://forums.phpfreaks.com/topic/33712-excel-to-mysql-import/#findComment-159544 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.