[AccessD] Reading FoxPro Tables

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jan 3 20:48:05 CST 2005


Marty:

There is a .dbc file which I pointed to at the request of the Connect dialog 
box.  Seemed to work except that not all of the .dbf table showed up for 
linking.

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 6:09 PM
Subject: Re: [AccessD] Reading FoxPro Tables


> Check if you have a .dbc file (metatable file) that incorporates the free 
> table directory.
> Try linking to that. It's existance is dependant on version of Foxpro.
> the OLE DB Provider may not work without it.
>
> I haven't tried it not sure of syntax but just point to dbf table 
> directory
>
> oConn.Open "Provider=vfpoledb;" & _
>          "Data Source=C:\vfp8\Samples\DatadbfDir;" & _
>           "SourceType=DBF;" & _
>          "Mode=ReadWrite|Share Deny None;" & _
>          "Collating Sequence=MACHINE;" & _
>          "Password=''"
>
> Rocky Smolin - Beach Access Software wrote:
>
>> 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
>>>
>>
>
> -- 
> 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