[AccessD] Reading FoxPro Tables

Drew:

The first problem is that when I try to link tables, in the combo box 'Files 
of Type' there's no Fox Pro option, unlike my A97 install.  There is ODBC 
Databases.

When I select that I get the Select Data Source dialog box.  In the File 
Data Source I have Microsoft FoxPro VFP Driver.dsn which I added but I'm not 
sure I did it correctly.  Anyway, when I select it I get a fatal error 
ODBC--call failed, Driver does not support this function (#0).

And that's where I'm currently stuck.

Rocky




----- Original Message ----- 
From: <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, January 03, 2005 7:05 AM
Subject: RE: [AccessD] Reading FoxPro Tables


> What error message are you getting from Access when trying to import or 
> link
> the data from the .dbf files?  Do the .dbf files have coinciding .inf 
> files?
> That's a file that Jet likes to put in there for Access to 'know' where 
> the
> .cdx files are for the .dbf files.  If there is a mapped drive letter in
> there, Access get's flaky, and doesn't ask for the location of the index
> files, it just assumes the worse and says it can't find them.
>
> Drew
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Saturday, January 01, 2005 10:03 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Reading FoxPro Tables
>
>
> Dear List:
>
> I have a requirement to get data from an application written in FoxPro.  I
> tried linking the tables to an Access database but apparently I can't do
> that.  I tried to set up the ODBC thingy in the ODBC manager but got stuck
> on the DSN field.  Don't know what to put there.
>
> Can someone get me pointed in the right direction?
>
> Many Thanks In Advance and a Happy New Year To All,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>