Re: Access import off Fox Pro Tables

Cindy,

I am having an issue installing the visual fox pro driver. When I download
and try to install from the link you provided, I am getting the error "The
feature you are trying to use is on a netowork resource that is not
available" I am trying to install this driver on a windows 2003 server with
IIS 6. How can I get this VFP odbc driver?

I would greatly appreciate any assistance from you.

thanks,
Sherazad

"Cindy Winegarden" wrote:

> Hi SS,
>
> Here's something I posted earlier. Not all of it may apply to you.
>
> Start with the latest ODBC driver for FoxPro and Visual FoxPro, available
> from
> http://msdn.microsoft.com/vfox­pro/downloads/addons/odbc.asp. 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 FoxPro Setup dialog. In the first box (Data
> Source Name) enter a friendly name that you will use to recognize 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 table 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.
>
>
> Over the years, new features have been added to Fox data tables. The ODBC
> driver is only compatible with features used in VFP6 and under, although
> tables created with VFP7, 8, or 9 that don't use any of the new features
> will still be compatible with ODBC. Since you've connected on other machines
> then your tables must not have any of the new data features.
>
>
>
>
> In Microsoft Access in the Link Tables dialog you'll have to scroll to the
> bottom of the Files of type combo box and choose ODBC Databases. From there
> you can choose the data source you set up earlier and then a dialog will
> come up allowing you to choose tables.
>
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "ss" <ss@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E2236A16-AC34-4AA5-9FDA-F14F313026BA@xxxxxxxxxxxxxxxx
> > How do I import or link an foxpro table to an Access database. I use
> > access
> > 2000 and fox pro 8.
> > In access 97 it is easy but I cant find out i access 2000.
>
>
>
.