Export data to dBASE

dBASE was one of the original database management systems and the dBASE file format (.dbf) has been around for a long time. Microsoft Access supports exporting to the following dBASE file formats: dBASE III, dBASE IV, dBASE 5, and dBASE 7.

Export data to a dBASE file

Note    dBASE support has the following requirements:

  • Office 365 subscription    If you are an Office 365 subscriber, make sure you have the latest version of Office. If you are an IT professional managing the Office 365 update process, check out the channel releases page to learn which updates are provided in each channel

  • Office 2016    Install the following updates in order: May 2, 2017, update for Office 2016 (KB3115501) and May 2, 2017, update for Access 2016 (KB3178700).

  • Office 2016 Click-to-Run editions    Updates are automatically applied.

  1. Select External Data, in the Export group select More, and then select dBASE File.

  2. In the Export – dBASE File dialog box, select Browse.

  3. In the File Save dialog box, locate a folder and enter a name in the File name box.

  4. The default file format is dBASE III. To change to dBASE IV or dBASE 5, select a file format from the Save as type box. Although dBASE 7 is not listed, dBASE 5 and DBASE 7 are essentially the same file format.

  5. Click Save.

  6. In the Export – dBASE File dialog box, you can also select the dBASE file format from the File format box.

  7. Select OK.

  8. Optionally, save the export steps. For more information, see Run a saved import or export operation.

As a result, a dBASE file is created in the location and file format you specified.

Access 2013 doesn't support dBASE

Exporting to dBASE is not supported in Access 2013. To work with dBASE files, consider upgrading to an Office 365 subscription. Exporting to dBASE is available in the Office 365 subscription versions of Access.

Try the new version of Outlook

Export data to a dBASE file

  1. Select External Data, in the Export group select More, and then select dBASE File.

  2. In the Export – dBASE File dialog box, select Browse.

  3. In the File Save dialog box, locate a folder and enter a name in the File name box.

  4. The default file format is dBASE III. To change to dBASE IV or dBASE 5, select a file format from the Save as type box. Although dBASE 7 is not listed, dBASE 5 and DBASE 7 are essentially the same file format.

  5. Click Save.

  6. In the Export – dBASE File dialog box, you can also select the dBASE file format from the File format box.

  7. Select OK.

  8. Optionally, save the export steps. For more information, see Run a saved import or export operation.

As a result, a dBASE file is created in the location and file format you specified.

Export data to a dBASE file

  1. Select External Data, in the Export group select More, and then select dBASE File.

  2. In the Export – dBASE File dialog box, select Browse.

  3. In the File Save dialog box, locate a folder and enter a name in the File name box.

  4. The default file format is dBASE III. To change to dBASE IV or dBASE 5, select a file format from the Save as type box. Although dBASE 7 is not listed, dBASE 5 and DBASE 7 are essentially the same file format.

  5. Click Save.

  6. In the Export – dBASE File dialog box, you can also select the dBASE file format from the File format box.

  7. Select OK.

  8. Optionally, save the export steps. For more information, see Run a saved import or export operation.

As a result, a dBASE file is created in the location and file format you specified.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×