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 >