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? Quote Link to comment 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. Quote Link to comment 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" Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
witch Posted December 25, 2006 Share Posted December 25, 2006 Sorry about that Mysty not Misty :-[ Quote Link to comment 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.