

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: Csv File, Database Manager, Excel Csv, Excel Database, Export Box, Export Options, Field Names, Macintosh, Microsoft, Microsoft Database, Microsoft Excel, Microsoft Windows, Ms Excel, Mysql Database, Null Values, Phpmyadmin, Platform Windows, Replacement String, Some File Formats













