Exporting SQL to Excel

[dreamerp]

Hello,

Does anyone know where I can learn how to export SQL to Microsoft Excel and also how to export Excel to SQL?

Any code or tutorials will help!

Thanks!

[teiz77]

@dreamerp

Hello,

Does anyone know where I can learn how to export SQL to Microsoft Excel and also how to export Excel to SQL?

Any code or tutorials will help!

Thanks!

What language do you want to use? If it’s PHP you can use the PEAR package Spreadsheet_Excel_Writer to write excel files. You can also use phpmyadmin to generate CSV files wich can be read by Excel. You can also use phpmyadmin to import CSV files into a database.