Access 2013 - Dbase (.dbf) Table Import option

Have you tried creating an ODBC DSN to your dBASE data file?  On a clean install of 32-bit Office 2013 on Win8, I find that I still have the ability to create a dBASE DSN.  dBASE is just not natively supported any longer.  

This has been an issue on other platforms for several years now. There never was a 64-bit dBASE driver, thus as an example websites have been struggling try to continue to use the out date format.

dBASE was a standard for many years, but it is not any longer...I don't miss it, it was not perfect.

Here we are in the very end of 2015.  A new release of Office (2016) still does not support dBase inmport/export.

Connecting to an ODBC to just get access to dBase files does not hack it for us, that use the export function to deliver dBase files for production equipment that can only use dBase format.

I our company we work with many databeases every day, finally delivering them in dBase format to out inkjet printers in the lettershop systems.  Oldfashioned?? Maybe so, but it WORKS.

I am now looking for a solution, BUT what kind of solution?  An external software is not practical, because it adds extra processes to our work - including extra posibilities of failure with updates......

I think a "module" mad specifically for Access in MS-VS, VBA or...... must be the solution.  Has anyone done this, or would you be interested in buying it for a fair price (since Microsoft doesn't care about our needs)?

I think I know someone that can do this.  So please let me know if you are interested.

Hi!

You have the possibility

1. Install official "Visual Fox Pro ODBC Driver"
2.  Create a new ODBC Driver:

    a. Driver "Microsoft FoxPro VFP Driver (*.dbf)"

    b. Select "Free table directory" option and select DBF files folder.

3. In Access you have the possibiity to choose this new ODBC profile to import data table, join, manage, ect... dbf as a table.

At disposal,

Stefano

Stefano, looks like you have something there. 

Unfortunately when you search for it, Microsoft directs you to FoxPro downloads, where it reports:

Visual FoxPro ODBC DriverThe VFPODBC driver is no longer supported. We strongly recommend using the Visual FoxPro OLE DB provider as a replacement. Please refer to the following article for more information and related links to issues when using the VFPODBC driver: http://support.microsoft.com/kb/277772.

But you may still have found what we need.  Thanks for the update.

Hi!

You have the possibility

1. Install official "Visual Fox Pro ODBC Driver"
2.  Create a new ODBC Driver:

    a. Driver "Microsoft FoxPro VFP Driver (*.dbf)"

    b. Select "Free table directory" option and select DBF files folder.

3. In Access you have the possibiity to choose this new ODBC profile to import data table, join, manage, ect... dbf as a table.

At disposal,

Stefano