Export data to dBASE

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

dBASE was one of the pioneering database management systems and the dBASE file format (.dbf) has existed for many decades. Microsoft Access helps with exporting to the following dBASE file formats: dBASE III, dBASE IV, dBASE 5, and dBASE 7.

Newer versions

Note:

dBASE support has the following requirements:

  • Office 365 subscription  –  If you are an Office 365 subscriber, check you have the most recent version of Office. If you are an IT professional managing the Office 365 update process, review the channel releases page to keep abreast of which updates are provided in each channel.

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

Export data to a dBASE file

  1. Click External Data, in the Export group, press More, and then choose dBASE File.
  1. In the Export – dBASE File dialogue box, tap Browse.
  1. In the File Save dialogue box, track down a folder and type a name in the File name box. The preset file format is dBASE III. To amend to dBASE IV or dBASE 5, pick a file format from the Save as type box. Despite dBASE 7 being unlisted, dBASE 5 and DBASE 7 are pretty much the equivalent file format. In Access for Office 365 and Access 2019, file names of up to 64 characters are maintained.
  1. Select Save.
  1. In the Export – dBASE File dialogue box, you can even pick the dBASE file format from the File format box.
  1. Press OK.
  1. Optionally, save the export steps. For more information, see Run a saved import or export operation.

Subsequently, a dBASE file is made in the location and file format you confirmed.

Leave a Reply

%d bloggers like this: