[AccessD] Reading FoxPro Tables

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Jan 4 11:37:38 CST 2005


Yeah, except there's no file export capability in this proprietary app I'm 
trying to get the data out of.  It's run time.

Rocky

----- Original Message ----- 
From: "William Hindman" <dejpolsys at hotmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, January 04, 2005 8:38 AM
Subject: Re: [AccessD] Reading FoxPro Tables


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