[AccessD] Reading FoxPro Tables

Didja look at this in the KB?

"HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000"

http://support.microsoft.com/?kbid=197893


On Mon, 3 Jan 2005 09:02:04 -0800, Rocky Smolin - Beach Access
Software <bchacc at san.rr.com> wrote:
> 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
> >
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
Gary Kjos
garykjos at gmail.com