Visual Fox Pro Conversion to Access

[SHIPP]

I have a Visual Fox Pro database that I want to convert to
Access. I have the executable but have not, as yet, found
the Source Code.

1. Does anybody know the extension for a Fox Pro database
source file so that I can do a search of the companies
servers? This is a Fortune 500 company and there are
literally hundreds if not thousands of servers.
2. Are there any utilities/tools available that might
assist me in the automated conversion of a Fox Pro
database to an Access database?

 

[John Vinson]

I have a Visual Fox Pro database that I want to convert to
Access. I have the executable but have not, as yet, found
the Source Code.

1. Does anybody know the extension for a Fox Pro database
source file so that I can do a search of the companies
servers? This is a Fortune 500 company and there are
literally hundreds if not thousands of servers.
2. Are there any utilities/tools available that might
assist me in the automated conversion of a Fox Pro
database to an Access database?

You may want to come to the Compuserve forum in my .sig - we have a
number of topnotch Visual FoxPro experts there who can surely help
with the first question. You will need an ID and password to connect
to the forum but it's free, you don't need a CompuServe membership.

As for the second... I doubt that there is any such tool at all.
Access and FoxPro are VERY different programs, in structure and in
concept; they're both relational database management systems but
that's about all they have in common. Access can import VFP table data
but the user interface - forms, reports, code - are altogether
different; they don't even "map" to one another very well.

 

[Cindy Winegarden]

Hi Mike,

You haven't said which version of FoxPro you think the application is
written in.

Moving the data from FoxPro tables to an MDB is pretty easy, as you probably
know (either natively for Fox2x format, or via ODBC for Fox2x or Visual
FoxPro format). Alternatively, you can just link the tables and leave them
in the FoxPro format.

However, there is nothing that will convert screens, reports, or XBase
program code although you might be able to use some SQL code as a basis for
the same thing in Access.

For more help try any of the FoxPro newsgroups - microsoft.public.fox.* - on
this news server.

The FoxPro application itself could be either an EXE, or an APP file. FoxPro
programs (PRGs) are text files so you can open them and easily see what's
inside. Other files such as screens and reports are actually tables, so you
wouldn't be able to do much with them unless you had FoxPro available.