Excel To Mysql Or Sql File Type - Webmasters - Nairaland
Nairaland Forum › Science/Technology › Webmasters › Excel To Mysql Or Sql File Type (1067 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
Oh My Website + Gtbank- Help Me! • Changing Host Service Provider • Free 1year Webhosting,Domain Name And Unlimited Webmails Plus Your Website.