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 Quote 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 Quote 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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.