pumaf1 Posted August 28, 2007 Share Posted August 28, 2007 Hi All, I am looking for a free peace of software which will alloy me to convert a spreadhseet with approx 3,000 rows into a mysql db. I have found a peace called xls2sql which does the job (really bloody well), but since i will only use it once, (once the data is collected) I would be a bit upset since the site doesnt make any money! if anyone can help i would really be happy! dave Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/ Share on other sites More sharing options...
fenway Posted August 28, 2007 Share Posted August 28, 2007 LOAD DATA INFILE -- check the refman. Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/#findComment-336594 Share on other sites More sharing options...
pumaf1 Posted August 28, 2007 Author Share Posted August 28, 2007 sorry i dont understand? am i just being stupid? Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/#findComment-336606 Share on other sites More sharing options...
fenway Posted August 29, 2007 Share Posted August 29, 2007 You can export excel to tab/csv, then use standard LOAD command. Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/#findComment-337239 Share on other sites More sharing options...
pumaf1 Posted August 29, 2007 Author Share Posted August 29, 2007 hits head against wall...... grrr just twigged thanks! Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/#findComment-337357 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.