Reverse Engineering a .DBF file

"I have a database file from  Fox Pro"

Could it be that you mean that you have a Foxpro application (maybe an EXE or APP file) instead of one or more database (now called - data table) files (DBF files)?

I personally would not recommend that you try to reverse engineer it yourself at all.

The first reason not to do so would be possible legality issues.  
Who OWNS the application at the code level?  
Just because an individual has purchased user licenses, doesn't mean that they OWN the application at the code level.   So reverse engineering an application could possibly be not legal and we wouldn't want to support assisting someone to break the law.

However, assuming that you do OWN the application at the code level, then to reverse engineer an application (I don't care what language it is written in) you need to first have a 100% understanding of how the application does what it does.  

You can attempt discover how things are being done by decompiling an application into its various source code files and then thoroughly studying the code, but if you don't completely understand the language then it doesn't do you much good.

Or you can have a 100% understanding on how things need to work to accomplish a set of tasks.  If you have that level of understanding, then you would not need to reverse engineer anything.  You could merely develop the code yourself in whatever language you wanted yourself.

If you should possibly have some hope that there might be some developer's tool out there to convert Foxpro code into another language, no such luck.

Good Luck

Do you want to import the VFP data into some other database. You can  connect to the VFP database with the VFP OLE DB driver. http://www.microsoft.com/downloads/details.ASPx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en

You can copy your DBF files into CSV, XLS or TXT format.

USE table
COPY TO myfile.csv TYPE CSV
COPY TO myfile.txt TYPE DELIMITED
COPY TO myfile.xls TYPE XLS

If you need to reverse engineer DBF files into Visio then you have to install VFP ODBC driver and connect Visio to DBF tables via this ODBC driver. Then you may use Visio Add-on tool named "Database Wizard" and import your DBF structures. I did not test it yet, the Wizard should guide you.

To expand on what pcelba said:

In Visio 2007:

• select File/New
• select  the Software and Database folder
• select  the Database Model Diagram
• after  the new document opens, select Database/Reverse  Engineer... and step through the wizard

Scott

Diagramming FoxPro: Visio Automation
http://www.aksel.com/whitepapers/VisioAutomation.htm

Step-by-Step Guide to Reverse Engineering a Database in Visio
http://msdn.microsoft.com/en-us/library/Aa140264

I keep having problems adding the data source.

I click the reverse engineer button >

The wizard pops up then I get a screen for ODBC Generic Driver >

Do I click set up or New?

I clicked new and said I don't have administrator privileges,

then I'm confused on what to do