[AccessD] Reading FoxPro Tables

One other way to perhaps get the proper connection string for foxpro on 
your machine
is use Notepad to open up a blank file
save as myfoxpro.udl
then double click on udl  with win explorer
fill in the wizard with foxpro and passwords etc
save
reopen udl file with notepad and cut and paste the connection string.

Then maybe use this code for a DSN-less Connection string
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

William Hindman wrote:

> ..iirc there was a bug with A2K ...try setting up a machine or user 
> DSN instead of a file DSN ...hth.
>
> 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: Saturday, January 01, 2005 3:39 PM
> Subject: Re: [AccessD] Reading FoxPro Tables
>
>
>> 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
>>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>

-- 
Marty Connelly
Victoria, B.C.
Canada