ballouta Posted September 23, 2008 Share Posted September 23, 2008 Hello I am not sure if this is the proper division to ask my question. I have a big books list on excel sheet. How i can save it (export it) as SQL and then import it to phpmyadin without re writeing and enetering all list from the begining? Note that my list is English-Arabic language Thank You Quote Link to comment https://forums.phpfreaks.com/topic/125545-solved-converting-from-excel-to-sql/ Share on other sites More sharing options...
Maq Posted September 23, 2008 Share Posted September 23, 2008 You should turn it into a CVS file, explode the columns, and insert into the proper tables/fields. Quote Link to comment https://forums.phpfreaks.com/topic/125545-solved-converting-from-excel-to-sql/#findComment-649111 Share on other sites More sharing options...
brianw Posted September 24, 2008 Share Posted September 24, 2008 I usually take the easy way out if I have alot that needs to be converted like that. I've used this software product and have been very happy with it. http://www.convert-in.com/ Quote Link to comment https://forums.phpfreaks.com/topic/125545-solved-converting-from-excel-to-sql/#findComment-649212 Share on other sites More sharing options...
Maq Posted September 24, 2008 Share Posted September 24, 2008 Cool, never seen this product before. They have everything! Quote Link to comment https://forums.phpfreaks.com/topic/125545-solved-converting-from-excel-to-sql/#findComment-649397 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.