[AccessD] Reading FoxPro Tables

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sat Jan 1 16:35:42 CST 2005


Marty:

Read access would be good enough. How do I check the Jet version?

Regards,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334

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


> Foxpro tables had problems due to political squabbling with Ashton Tait 
> and Borland back then make sure you are using Jet version 7 or 8
> If you look through the Jet Version file manifests 4 through 7 there is 
> some explanation.
> At one point in the versions changes you only had read access to linked 
> dbf tables
>
> Rocky Smolin - Beach Access Software wrote:
>
>> No - it's going to be an app external to a proprietary system from which 
>> they want to pull data periodically to do some business analysis and 
>> other reporting.
>>
>> Turns out I can connect directly to the .dbf tables if I use Access 97. 
>> 2000 won't for some reason.
>>
>> So I'm past the hump for Monday's meeting with the client.  But I think 
>> I'll have to get it working in 2000 pretty quickly.
>>
>> Rocky
>>
>> ----- Original Message ----- From: "Joe Hecht" <jmhla at earthlink.net>
>> To: "'Access Developers discussion and problem solving'" 
>> <accessd at databaseadvisors.com>
>> Sent: Saturday, January 01, 2005 10:28 AM
>> Subject: RE: [AccessD] Reading FoxPro Tables
>>
>>
>>> Morning Rocky,
>>>
>>> Glad I am not the only one working today.
>>>
>>> If this is a one time pull  of data you can try going through Excel to 
>>> get
>>> the data.
>>>
>>> HTH
>>>
>>>
>>> JOE HECHT
>>> LOS ANGELES CA
>>> jmhla at earthlink.net
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
>>> Smolin -
>>> Beach Access Software
>>> Sent: Saturday, January 01, 2005 8: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
>>>
>>
>
> -- 
> 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