msgbartop
Gossimer’s Premier Web Hosting and Domain Registration Knowledgebase.
msgbarbottom

27 Aug 10 How do I export a table from a MySQL database to a tab delimited file for use in Microsoft Excel?

The Database Manager allows you to export a database (or selected tables) to a file. Some file formats allow you to view the records in another application, such as Microsoft Excel.

CSV for MS Excel A CSV file optimized for use in Microsoft Excel.

To export a CSV file:

1. Connect to your database. You can do this remotely, or using phpMyAdmin.

2. Select the desired tables.

3. Select CSV from the Export box.

4. Now, set the desired CSV Options.

5. Check the Save as file check-box.

6. Click on Go.

There are only three CSV for Microsoft Excel export options: replacement string for NULL values, put field names at first row, and specify Excel platform (Windows or Macintosh).  


To export a CSV for Microsoft Excel file:

1. Connect to your database. You can do this remotely, or using phpMyAdmin.

2. Select the desired tables.

3. Select CSV for MS Excel from the Export box.

4. Set the desired export options.

5. Check the Save as file check box.

6. Click Go.
 

Tags: , , , , , , , , , , , , , , , , , ,


SEO Powered By SEOPressor