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 >