Excel To Mysql Or Sql File Type - Webmasters - Nairaland
Nairaland Forum › Science/Technology › Webmasters › Excel To Mysql Or Sql File Type (1068 Views)
1 Reply
| Excel To Mysql Or Sql File Type by pagolina(op): 3:50pm On May 06, 2010 |
I have a file in m.s excel, i want to export it to .sql format so i can easly inport it via phpmyadmin. how do i get the excel file in .sql format? your response is highly welcome |
| Re: Excel To Mysql Or Sql File Type by OmniPotens(m): 3:59pm On May 06, 2010 |
Try google for now. When peeps are free then more responses. Just came in to deal with spam posts. See you later |
| Re: Excel To Mysql Or Sql File Type by Nobody: 2:55pm On May 07, 2010 |
first you open the document in excel and use the "save as" to save it as "comma separated (*.csv)" that format is a plain text file. then you visit phpmyadmin and import. i know there is an option to import csv into phpmyadmin. but i cannot remember the details right now. but if you run into any trouble, please send the exact error report to support@.com as i may not be around here |
Who Can Share Me Nairaland Sql File • Import Excel Sheet To Mysql Database • Mysql: Cannot Connect To Mysql, Access Denied For Root@localhost • 2 • 3 • 4
Want To Make Money Online? • Has Anyone Tried Softpay.org's Virtual Credit Card? • Why Ranjan Das ( Ceo Of Sap India) Passed Away? [a Must Read]