MartyConnelly
martyconnelly at shaw.ca
Sat Jan 1 15:44:47 CST 2005
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