Excel DbfMate

Excel DbfMate is a reliable Microsoft Excel add-in that facilitates the information transfer between the selected spreadsheets and FoxPro databases. The tool is easy to use permits both exporting the data from Excel and importing it from a DBF file. It integrates with the Excel context menu, for convenient usage.

Excel DbfMate allows you to migrate data from the spreadsheet you are working in to a DBF file, with a few mouse clicks. Alternatively, it allows you to import data from the aforementioned files, right into the selected worksheet.

The tool allows you to import information from several DBF formats, namely for DBase III Plus, Visual FoxPro and DBase IV. The data export is only supported for the first two formats, however.

The task is simple: select the desired range in Excel, then prompt open the transfer window: right-click and access it from the context menu or open it from the Add-ins tab. The transfer can be configured from an import/export wizard.

Excel DbfMate allows you to set several details before migrating the data: select the column headers location, the source range and output options. You can export data to a dBase or Visual FoxPro file, using the specified code page. Moreover, the output location can be manually selected.

You may exclude one or more columns from the transport, if, for instance they are located between required ones. Importing data from supported DBF files is accomplished in a similar manner: select the location in the spreadsheet, choose whether to import column names, deleted records or trailing spaces.

Both the import and export functions of Excel DbfMate allow you to make advanced selections of the data you wish to transfer. Not only can you preview the contents that are about to be migrated, but you may choose to exclude certain columns from the selected range. The process is straightforward and transparent.