lional Posted February 1, 2008 Share Posted February 1, 2008 Hi All I am trying to write a script but before I start I would like to know if it is possible. I want to use an excel spreadsheet or a csv file to import data into a mysql products table that will update the products table with the spreadsheet. Is this possible Thanks Lional Link to comment https://forums.phpfreaks.com/topic/88836-importing-from-csv-or-excel/ Share on other sites More sharing options...
pdkv2 Posted February 1, 2008 Share Posted February 1, 2008 yes it is possible ! you will have to use the php pear classes for this purpose Link to comment https://forums.phpfreaks.com/topic/88836-importing-from-csv-or-excel/#findComment-455005 Share on other sites More sharing options...
lional Posted February 1, 2008 Author Share Posted February 1, 2008 I am fairly new to php so firstly what is the php pear calsses and just point me in the right direction. I don't what the script to be written for me, but just a few pointers Link to comment https://forums.phpfreaks.com/topic/88836-importing-from-csv-or-excel/#findComment-455029 Share on other sites More sharing options...
aztec Posted February 1, 2008 Share Posted February 1, 2008 Hello I used a program called SQLyog which will allow you to inport a CVS file. Sorry I cannot be more specific but it was some time ago. I know it worked with an Excel sheet I needed to get into mysql, you can download it for free at some sites. I also remember that when I searched there were other programs that will do what you require. Regards Link to comment https://forums.phpfreaks.com/topic/88836-importing-from-csv-or-excel/#findComment-455251 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.