₦airaland Forum

Welcome, Guest: Register • Login • With Google • Trending • Recent • New

Stats: 3,345,799 members, 8,519,487 topics. Date: Monday, 16 November 2026 at 11:00 AM

Toggle theme

Excel To Mysql Or Sql File Type - Webmasters - Nairaland

Nairaland Forum › Science/Technology › Webmasters › Excel To Mysql Or Sql File Type (1089 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 File • Import Excel Sheet To Mysql Database • Mysql: Cannot Connect To Mysql, Access Denied For Root@localhost • 2 • 3 • 4

Graphic Design,web Design And Motion Graphics Training Coming Up 29th Of October • StayHooked To Web4africa, Another Great Hosting Service Company In Nigeria • Designing A Mobile Site