Export To DBF

ExportToDBF.SK is used to generate a dBase Database file (.dbf file).

Example:

Given below is the sample data set for which we are going to generate the DBF file.

1. Go to the SheetKraft Ribbon, then go to export and then select the Export To DBF as shown in the figure.

2. A dialog box will appear. Select the desired range for which you want to generate the DBF file and then click on OK as shown in the figure

3. The following UI will be shown.

  • Data Range: It shows the cell reference foe which you want to generate the DBF file.

  • Column Specification has two arguments:

    • Headers: You can alter the column header name over here. If you want to show selective columns in your file then uncheck the check boxes in order to deselect them. By default all the columns are selected.

    • Date Type:

    • Character: If the column contains Alphabets, special character or alphanumeric data then select character.

    • Numeric: If the column contains numeric data like amount, units then select this datatype.

    • Date: If the data is date then select this datatype.

    • Logical: If the data in the column can have only two values either TRUE or FALSE then use logical datatype.

  • File Type: Currently dBaseIII file type is only supported.

  • Export Range to the file: Select the button with three dots and browse the folder in which you want to save the file and provide the file name.

4. After filling all the details in step 3, click on Next and select the blank range in your worksheet and click on OK as shown in the figure.

5. Final Output