[AccessD] Reading FoxPro Tables

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jan 3 19:30:39 CST 2005


Marty:

I was hoping to link to these table inthe database container and avoid the 
coding.

But if I hafta, I hafta.

Rocky

----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, January 03, 2005 4:42 PM
Subject: Re: [AccessD] Reading FoxPro Tables


> Instead of using the ODBC how about "Microsoft OLE DB Provider for Visual 
> FoxPro 8.0" , the ODBC is good only up to Visual FoxPro 6.0
> 9.0 is out in Beta.
>
> Microsoft OLE DB Provider for Visual FoxPro 8.0
> It should be backward compatible. How far back I dunno.
> The Visual FoxPro OLE DB Provider is supported by OLE DB System Components 
> as provided by MDAC 2.6 or later
> Mdac 2.6 is installable by Win98 SE +
> However MDAC 2.7 is Win2000+
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
>
> Sample connection string
>
> OLE DB Provider for Visual FoxPro
> oConn.Open "Provider=vfpoledb;" & _
>           "Data Source=C:\vfp8\Samples\Data\myVFPDB.dbc;" & _
>           "Mode=ReadWrite|Share Deny None;" & _
>           "Collating Sequence=MACHINE;" & _
>           "Password=''"
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/foorivisualfoxprodataaccessusingoledbprovider.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgtskaccessingvisualfoxprodatainmicrosoftofficexp.asp
>
> Visual FoxPro 9.0 Beta
> Download for Microsoft Visual FoxPro 9.0 public beta. Good until March 31 
> 2005
>
> http://www.microsoft.com/downloads/details.aspx?familyid=23fbc57b-93b0-4cb7-b376-53ca04fca159&displaylang=en
>
> Rocky Smolin - Beach Access Software wrote:
>
>> Making some progress.  I downloaded from:
>>
>> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
>>
>> Now I can link some of the tables by selecting ODBC databases, then in 
>> Select Data Source select Visual FoxPro Database, in the Configure 
>> Connection dialog select Free Table Directory, browse to the directory 
>> containing the free tables, clock OK then I get a list of tables but not 
>> all of the .dbf tables are in the link list that are in the directory.
>>
>> So I'm getting closer.
>>
>> Do you know of some reason why all of the tables wouldn't appear in the 
>> link tables list?
>>
>> Regards,
>>
>> Rocky Smolin
>> Beach Access Software
>> http://www.e-z-mrp.com
>> 858-259-4334
>>
>>
>> ----- Original Message ----- From: "Gary Kjos" <garykjos at gmail.com>
>> To: "Access Developers discussion and problem solving" 
>> <accessd at databaseadvisors.com>
>> Sent: Monday, January 03, 2005 3:14 PM
>> Subject: Re: [AccessD] Reading FoxPro Tables
>>
>>
>>> Crud....how about this stuff. Might give you some clues anyway.
>>>
>>> http://support.microsoft.com/kb/q200393/
>>> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
>>> http://www.experts-exchange.com/Databases/FoxPro/Q_20924251.html
>>> http://www.experts-exchange.com/Databases/FoxPro/Q_21046680.html
>>> http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
>>>
>>>
>>> On Mon, 3 Jan 2005 14:43:59 -0800, Rocky Smolin - Beach Access
>>> Software <bchacc at san.rr.com> wrote:
>>>
>>>> Gary:
>>>>
>>>> Failed.  It tells me to download the latest version of MDAC.  SO I 
>>>> download
>>>> 2.8 and it tells me that it's incompatible with my current OS.
>>>>
>>>> So I go to the instructions to create the data source in the Control 
>>>> Panel.
>>>> But I get an error when I select the Visual FoxPro driver - tells me I 
>>>> must
>>>> install the current version of the visual FoxPro driver and directs me 
>>>> to a
>>>> page that no longer exists to get the update.
>>>>
>>>> Microsoft...gotta love 'em.
>>>>
>>>> Rocky
>>>>
>>>> ----- Original Message -----
>>>> From: "Gary Kjos" <garykjos at gmail.com>
>>>> To: "Access Developers discussion and problem solving"
>>>> <accessd at databaseadvisors.com>
>>>> Sent: Monday, January 03, 2005 10:19 AM
>>>> Subject: Re: [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
>>>> > --
>>>> > 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
>>> -- 
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list