[AccessD] Reading FoxPro Tables

William Hindman dejpolsys at hotmail.com
Tue Jan 4 01:18:38 CST 2005


..did you select dbIII as the file type? ...some pre VFP dbfs will not show 
unless you ask to see the dbIII ones.

William Hindman


----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, January 03, 2005 9:48 PM
Subject: Re: [AccessD] Reading FoxPro Tables


> 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
>>
>
> -- 
> 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