Convert FoxPro to Access?

[TomT]

I have a client whose main application was developed using FoxPro. I was
wondering if there is any way to convert this to MS Access, or barring that,
does anyone have any suggestions as to how to move from a FoxPro based app to
MS Access?

Thanks for any help,

TomT

 

[Chris Mills]

You're in for a complete total absolute re-write. You can only convert data.

You can "link to data", if FoxPro does the main stuff and you just want
further reports etc.

If security is a consideration, MS-Access isn't that great (not sure about
FoxPro but isn't it fully compiled?)

Chris

 

[Sophie Guo [MSFT]]

Hello,

Based on my knowledge, Microsoft does not provide such a utility to
automatically convert Visual Foxpro forms and report to Access format. You
can only
transfer the data from Visual Foxpro to Access, then re-create the forms
and reports in Access based on the transferred data. You may perform the
following steps:

1. Create a new blank Access database.

2. Import or create linked tables to the original Visual Foxpro database in
the new Access database by referring to the following article:

Q286815 HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2002
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q286815>

225861 No options are available to import, link, or export to the FoxPro
file
http://support.microsoft.com/?id=225861

3. Create Access forms based on the imported or linked tables in Access.

4. Create Access reports based on the imported or linked tables in Access.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[TomT]

Chris,

Thanks for the information. I suspected as much.

 

[Sophie Guo [MSFT]]

Hello,

For your reference, you may import data from the FoxPro database into SQL
server database using SQL DTS Import/Export Wizard. You may refer to the
following information:

DTS Import/Export Wizard
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_
tools_wiz_8vsj.asp

Data Conversion and Transformation Considerations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_
usage_3ayb.asp

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Douglas J. Steele]

Sophie: This is an Access newsgroup. Why would you advise porting the data
from FoxPro to SQL Server when Access is more than capable of extracting the
data?

 

[TomT]

Doug,

I was the one who brought SQL Server up in the post she was responding to....

Tom