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 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. 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/ 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! 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
Archived
This topic is now archived and is closed to further replies.