Link Foxpro tables to Access "James D. Houston" <jd_houston[ at ]earthlink.net> 07.07.2006 16:15:32 I just got around to installing Office 2003 and was trying to link some Foxpro 6 tables to an Access database. But when I bring up the link dialog box, I don't see an option for Foxpro tables. Is there some component I need to install that I missed? Or can I just use one of the various dBase options (that dosen't seem likely)? Thanks in advance.

RE: Link Foxpro tables to Access Klatuu 07.07.2006 17:15:02 If the files are .dbf format, then you would use one of the Dbase options. "James D. Houston" wrote: [Quoted Text] > I just got around to installing Office 2003 and was trying to link some > Foxpro 6 tables to an Access database. But when I bring up the link dialog > box, I don't see an option for Foxpro tables. Is there some component I > need to install that I missed? Or can I just use one of the various dBase > options (that dosen't seem likely)? Thanks in advance. > > >

Re: Link Foxpro tables to Access "Joe Fallon" <jfallon1[ at ]nospamtwcny.rr.com> 08.07.2006 01:38:29 Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: Start with the latest ODBC driver for FoxPro and Visual FoxPro, available from http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx. Download and install it. (If you have trouble doing this, post back.) You will need to determine whether you have FoxPro "free" tables or a "database container" (contains metadata about the tables themselves). To do this, navigate to your data directory and look for the presence of a DBC file. If it's there you have a "database" otherwise you have free tables. Now open up the ODBC dialog. In WinXP it's Start | Administrative Tools | Data Sources (ODBC). Choose either the User DSN or the System DSN. (The difference lies in whether you want other people to be able to see it if they use your machine.) Click Add... Scroll down to the Microsoft Visual FoxPro Driver. Scroll over to verify that it's version 6.01.8629.01. Click Finish. Now you're at the ODBC Visual FoxPr Setup dialog. In the first box (Data Source Name) enter a friendly name that you will use to recognise this data source - My FoxPro Data Source. You can add more text in the description box. Below are two options. Choose Visual FoxPro database (.DBC) or Free Table Directory - whichever you have determined is correct. Browse to locate your directory, or your specific DBC file. You can click the Options>> button for more choices. The defaults should be ok. "Exclusive" refers to whether you want to have exclusive access to the data while you're using it. "Null" allows you to enter Null values or not. Older FoxPro tables do not allow Nulls. "Deleted" means to hide deleted records. This one's important if you are working with primary keys - more in a minute. "Fetch data in background" will allow you to see the first few lines of a large tablel while the rest is being retrieved. You can also indicate a collating sequence if you're using a non-English alphabet. Click OK and you're done. Now, about deleted records. When a record is deleted in a FoxPro or Visual FoxPro table it's merely marked as deleted and filtered out, but is still physically present in the table. If you have a unique index and you delete the record with a key value of 123 you can not enter another record with this value, even though you can't see the record. To get rid of records entirely, you must issue a PACK command. However, the best rule to follow is to not reuse primary keys. -- Joe Fallon "James D. Houston" <jd_houston[ at ]earthlink.net> wrote in message news:uYMOWCeoGHA.516[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] >I just got around to installing Office 2003 and was trying to link some >Foxpro 6 tables to an Access database. But when I bring up the link dialog >box, I don't see an option for Foxpro tables. Is there some component I >need to install that I missed? Or can I just use one of the various dBase >options (that dosen't seem likely)? Thanks in advance. >

Re: Link Foxpro tables to Access "Cindy Winegarden" <CindyWinegarden[ at ]newsgroups.nospam> 09.07.2006 21:13:01 Hi Klatuu, Joe Fallon has nicely posted my answer for me, but just so you'll know, James said he had Visual FoxPro 6 tables and they aren't accessible via any of the Dbase options. Only FoxPro 2.x tables are in a Dbase compatible format. -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy[ at ]cindywinegarden.com "Klatuu" <Klatuu[ at ]discussions.microsoft.com> wrote in message news:8EEF5EA7-7DE2-45AC-A174-08A9056E806D[ at ]microsoft.com... [Quoted Text] > If the files are .dbf format, then you would use one of the Dbase options. >> Foxpro 6 tables

Re: Link Foxpro tables to Access Klatuu 10.07.2006 13:05:02 Good, however, FoxPro 3.x still gave the option of using the dbf format. That is about the last time I used FoxPro. "Cindy Winegarden" wrote: [Quoted Text] > Hi Klatuu, > > Joe Fallon has nicely posted my answer for me, but just so you'll know, > James said he had Visual FoxPro 6 tables and they aren't accessible via any > of the Dbase options. Only FoxPro 2.x tables are in a Dbase compatible > format. > > -- > Cindy Winegarden MCSD, Microsoft Most Valuable Professional > cindy[ at ]cindywinegarden.com > > > "Klatuu" <Klatuu[ at ]discussions.microsoft.com> wrote in message > news:8EEF5EA7-7DE2-45AC-A174-08A9056E806D[ at ]microsoft.com... > > If the files are .dbf format, then you would use one of the Dbase options. > > >> Foxpro 6 tables > > >