[AccessD] Importing a FoxPro table into Access

Julie,

With each upgrade of a M$ product they tend to drop support of old file
formats.  Your version of FoxPro may be one of those dropped from
support from A97 to A2K.  If that is the case, then you may have to
export the data from FoxPro to a format that is common to both that
version of FP and A2K, such as comma delimited text, and then import
that intermediate file.

If you tell us what version of FP, I am sure somebody on this list will
be able to verify whether that file version is still supported by A2K or
not.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] 
Sent: Thursday 2003 Apr 03 09:58
To: accessd at databaseadvisors.com
Subject: [AccessD] Importing a FoxPro table into Access

A friend was using Access 97 and has since upgraded to Access 2000.
Their 
medical software was written in FoxPro.  Some of the data in FoxPro was 
being imported into the Access 97 database and being used to send
patient 
letters, postcards, etc.  Worked great.  Now that they have upgraded to 
Access 2000, they are no longer able to import the data.  Is there a 
different way to do this in A2000?  They had simply set up a macro.



Julie Reardon-Taylor
PRO-SOFT OF NY, INC.
www.pro-soft.net