mysty Posted December 22, 2006 Share Posted December 22, 2006 I will be making a site that is made up of names and addresses (PHP/MySQL). I have several of the names and addresses in Excel spreadsheets and would like to avoid re-typing them into the site's database. Is there a way to do that and if so, how? Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/ Share on other sites More sharing options...
fenway Posted December 22, 2006 Share Posted December 22, 2006 LOAD DATA FROM INFILE allows you to specify the necessary field/row terminators. Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/#findComment-146565 Share on other sites More sharing options...
mysty Posted December 22, 2006 Author Share Posted December 22, 2006 I am not sure I understand "LOAD DATA FROM INFILE" Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/#findComment-146580 Share on other sites More sharing options...
artacus Posted December 23, 2006 Share Posted December 23, 2006 The easiest way is to save the data as a CSV file and importing it using phpMyAdmin or similar app. Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/#findComment-146797 Share on other sites More sharing options...
witch Posted December 25, 2006 Share Posted December 25, 2006 Hey Misty,Plse see the following link.http://www.webthang.co.uk/tuts/tuts_dbase/convert/convert.aspI think this will work for you and the tutorial is excellent.The Witch Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/#findComment-147622 Share on other sites More sharing options...
witch Posted December 25, 2006 Share Posted December 25, 2006 Sorry about that Mysty not Misty :-[ Link to comment https://forums.phpfreaks.com/topic/31588-converting-excel-to-mysql/#findComment-147623 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.