Export SQL file into Excel

Question

I have a sql file which has a lot of insert statements (1000+),

e.g.

insert into `pubs_for_client` (`ID`, `num`, `pub_name`, `pub_address`, `pub_tele`, `pub_fax`, `pub_email`, `publ_website`, `publ_vat`, `pub_last_year`, `titles_on_backlist`, `Personnel`) values('2475','2473','xxx xxx xxx','xxx xxx, xxxx, xxxx, xxxx, ','000000 ','0000 ',NULL,NULL,NULL,NULL,NULL,NULL);

My client wants these in an excel file.

Is it possible to extract the information from this sql file and import it into an excel spreadsheet? I'm using excel 2007.

Answer 1

If you have a mysql installation somewhere and phpMyAdmin, just import the .sql file and export the table as .xls file directly from within phpMyAdmin.

Answer 2

edit: If you want to extract the data from the Insert statements without actually running them, you could:

• Save the SQL file as a CSV file
• Open it in Excel and it will automatically split the statements up into bits using the commas
• Most of the columns to the left of the data wont be worth keeping, so delete them
• The right-most columns should contain the data