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 Quote 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. Quote 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? Quote 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. Quote 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! Quote Link to comment https://forums.phpfreaks.com/topic/67111-solved-xls-to-sql/#findComment-337357 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.