Original Poster Posted December 7, 2010 Share Posted December 7, 2010 I need to upload loads of data from microsoft xl into a phpmyadmin .... im not sure how to do this as ive only ever used SQL code to insert data but there is so much data in this its just silly. Link to comment Share on other sites More sharing options...
0 firey Posted December 7, 2010 Share Posted December 7, 2010 is it a CSV file? If so.. PHPMYAdmin supports CSV uploading/inserting Link to comment Share on other sites More sharing options...
0 Original Poster Posted December 7, 2010 Author Share Posted December 7, 2010 i can make it a cvs yea i know that but it dosent read it for some reason Link to comment Share on other sites More sharing options...
0 Original Poster Posted December 7, 2010 Author Share Posted December 7, 2010 dont worry people i found my own method ... i just got it to show me the code it failed with took the data pasted it added all the punctuation needed using a text replacer and also added SQL code ... all dandy cheers Link to comment Share on other sites More sharing options...
Question
Original Poster
I need to upload loads of data from microsoft xl into a phpmyadmin .... im not sure how to do this as ive only ever used SQL code to insert data but there is so much data in this its just silly.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts