Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Note    dBASE support has the following requirements:

  • Microsoft 365     If you are a Microsoft 365 subscriber, make sure you have the latest version of Office. If you are an IT professional managing the Microsoft 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.

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.

    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. In Access for Office 365 and Access 2019, file names of up to 64 characters are supported.

  4. Click Save.

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

  6. Select OK.

  7. 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 Microsoft 365subscription. Exporting to dBASE is available in the Microsoft 365 subscription versions of Access.

Buy or try Microsoft 365

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×