# Connect to Visual FoxPro data for read / write

**URL:** <https://forum.knime.com/t/connect-to-visual-foxpro-data-for-read-write/90863>\
**Category:** KNIME Analytics Platform\
**Tags:** database\
**Created:** [December 1, 2025, 3:32pm UTC](https://forum.knime.com/t/connect-to-visual-foxpro-data-for-read-write/90863 "2025-12-01T15:32:41Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [December 2, 2025, 10:46am UTC](https://forum.knime.com/t/connect-to-visual-foxpro-data-for-read-write/90863/3 "2025-12-02T10:46:43Z")

</div>

@bbrink I was able to access FoxPro (dbf) databases thru some drivers in KNIME. First you register a custom database in the KNIME preferences like this. Yes, with all three drivers ([com.wisecoders:dbf-jdbc-drive](https://mvnrepository.com/artifact/com.wisecoders/dbf-jdbc-driver), [com.h2database:h2](https://mvnrepository.com/artifact/com.h2database/h2), [com.github.albfernandez:javadbf](https://mvnrepository.com/artifact/com.github.albfernandez/javadbf)):

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/1/0139d5323dff8472c5a5774ed34d4d47c694f63c.png)

The URL Template is this:

```auto
jdbc:dbschema:dbf:/<database>

```

Then you configure the DB Connector node with a custom string pointing to the location of your DBF files (the folder not the individual file although that might also work):

```auto
jdbc:dbschema:dbf:/<PATH>?charset=windows-1252

```

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/7/07a1c21f6d4f1612dc6970b2b0859054f9507d55.png)

You can let a Java Snippet create the path dynamically on your system.

Now you should be able to select the database you want. Remember: you might have to tweak the charset settings.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/e/3e1db5a09dc9163d03d11f88f04d60a6d7d648d7.png)

You can check this workflow using [sample DBFs](https://stackoverflow.com/a/31466229) with more detailed instructions how to install the drivers:

> **[DB SQL - FoxPro Database DBF – mlauber71](https://hub.knime.com/mlauber71/spaces/Examples/DB%20SQL%20-%20FoxPro%20Database%20DBF~_5AEClHURv_xgil6/current-state)**
>
> Access FoxPro DBF files with the help of KNIME nodes and Maven drivers

Another option could indeed be to use a [Python or R library](https://forum.knime.com/t/dbf-file-reading/1782/6) as @ActionAndi has suggested if the DBF files would allow that.

---

_[View the full topic](https://forum.knime.com/t/connect-to-visual-foxpro-data-for-read-write/90863)._