[AccessD] Reading FoxPro Tables

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


..as a side note, my preferred approach would have been to have FP export 
the files as ascii text and then import them into Access ...seems to solve a 
lot of file format problems and you can customize the hell out of an ascii 
import module.

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: Tuesday, January 04, 2005 10:57 AM
Subject: Re: [AccessD] Reading FoxPro Tables


>I get two terse responses from the linker depending on which table I try to 
>link: 1) The Microsoft Jet database engine could not find the object 
>'hreceived.DBF'.  Make sure the object exists and that you spell its name 
>and path name correctly. (Although I picked it off the list of tables, so I 
>know it's there and spelled correctly), and 2) External table is not in the 
>specified format.
>
> (Deep sigh).  Well, it may be moot anyway.  Client has discovered a third 
> party query and reporting tool for FoxPro, looks kind of like Crystal 
> reports from the web site, and they can use that to extract data to shoot 
> over to an Access-based business analysis and reporting module which they 
> want me to write.
>
> Still, I'd like to figure this one out.  They told me that the guy who 
> wrote the system is a one-man band, and very hard to get ahold of.
>
> Rocky
>
> ----- Original Message ----- 
> From: "William Hindman" <dejpolsys at hotmail.com>
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Sent: Monday, January 03, 2005 11:18 PM
> Subject: Re: [AccessD] Reading FoxPro Tables
>
>
>> ..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
>>>
>> -- 
>> 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