Re: Access import off Fox Pro Tables

Try http://msdn.microsoft.com/vfoxpro/downloads/updates/ .

--
Cindy Winegarden Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
http://spaces.msn.com/members/cindywinegarden


"Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5FEB345-2205-4E49-8B0F-AD2606B7CE88@xxxxxxxxxxxxxxxx
> 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.
>>
>>
>>


.