Opening a Foxpro DBF file from Access

[smsmail]

Hello All,

Can I open an Foxpro DBF file from Access? If so, can you please supply an example of the code.

Thanking you in advance!

 

[dhookom]

Have you tried using the External Data functionality to link to or import DBF files.

Duane
Hook'D on Access
MS Access MVP

 

[smsmail]

Hi Dhookom,

I am not familiar with the External Data functionality. Will this allow me to programmatically get a dbf file within Access.

I have a form that displays in a text box, a path name of of a file. The user can view that data by clicking a "view data" button. If the file is a .XLS or CVS, the code below opens up to an excel spreadsheet:

Dim oApp As Object
 Set oApp =     CreateObject("Excel.Application")
 oApp.Visible = True
 oApp.UserControl = True
 oApp.Workbooks.Open strDataPathName

I need the code that will open up the foxpro database if the file is a DBF.

Can I programatically do this with the external data function?

 

[dhookom]

I expect you could change the connection properties of the linked dbf file to point to whatever file the user wants.

The first test is if you can use the External Data to connect to any foxpro file.

Duane
Hook'D on Access
MS Access MVP