Access import off Fox Pro Tables

[ss]

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.

 

[Cindy Winegarden]

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.

 

[Sher]

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]

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

 

[Sher]

Thanks for your assistance Cindy.

I do have another issue cropping up if you don't mind. I have migrated a web
application to Windows 2003, IIS 6, which is using the visual fox pro driver
to read and write data to a fox pro database. It is an application that is
used to allow employees to submit requests to be registered in courses. We
have confirmed that the employee is able to register for courses and the data
is being written to the database. The manger is then able to approve the
course, however, on data does not show up in the manager view i.e no records
show up on the asp page. I have even tried running the query in SQL server
Query analyzer using a linked server to the fox pro database, but I still am
unable to see the data. This all currently works properly on a windows NT 4.0
server with IIS 4.0. Any ideas of what the problem might be? Any assistance
would be greatly appreciated.

thanks,
Sher.