₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,327,348 members, 8,430,551 topics. Date: Saturday, 20 June 2026 at 05:13 PM

Toggle theme

Excel To Mysql Or Sql File Type - Webmasters - Nairaland

Nairaland ForumScience/TechnologyWebmastersExcel 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
1 Reply

Who Can Share Me Nairaland Sql FileImport Excel Sheet To Mysql DatabaseMysql: Cannot Connect To Mysql, Access Denied For Root@localhost234

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]