Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Jan 3 18:04:10 CST 2005
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 >