# Exporting SQL to Excel

**URL:** <https://forum.kirupa.com/t/exporting-sql-to-excel/186252>\
**Category:** programming\
**Created:** [April 20, 2006, 2:46am UTC](https://forum.kirupa.com/t/exporting-sql-to-excel/186252 "2006-04-20T02:46:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dreamerp](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dreamerp](https://forum.kirupa.com/u/dreamerp)\
**Post date:** [April 20, 2006, 2:46am UTC](https://forum.kirupa.com/t/exporting-sql-to-excel/186252/1 "2006-04-20T02:46:17Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![teiz77](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/teiz77/32/771_2.png) [@teiz77](https://forum.kirupa.com/u/teiz77)\
**Post date:** [April 20, 2006, 8:06am UTC](https://forum.kirupa.com/t/exporting-sql-to-excel/186252/2 "2006-04-20T08:06:14Z")

</div>

> [@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](http://pear.php.net/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.