Visual Foxpro conversion for Access 2003

[Pete]

In Access 2000 I was able to import from Foxpro, under
the option of File Type being ODBC and then the tab for
Machine Data sources. This option set is not present in
Access 2003, and I cannot load Access 2000 on my new XP-
based machines as my upgrade path on the old machine was
going back to upgrades which my new machine won't allow
me to install the old CDs on.

Thanks in advance.

 

[Cindy Winegarden]

Hi Pete,

I'm not an Access guru but here's what worked - If you Ctrl+F1 to bring up
the task pane and choose Blank database (top of the list) you get an MDB
instead of an ADP. With the MDB you can proceed as in Access 2000.

 

[Pete]

Just tried it--my only options are DBASE, EXCEL or MS
Access for machine data imports--thanks for trying to
help however! I then tried to click ADD and was directed
to the MS Knowledge Base. There is a driver at
http://www.msdn.microsoft.com/vfoxpro/downloads.

If it does not work I'll post an update.

 

[Pete]

Well the driver I downloaded will not run--it is only for
those who already have Visual Foxpro--there are too many
optoins on the download page for me to figure out which
one will enable me to import....thanks for trying
Cindy...hopefully we will get another reply from someone
who has done this!

 

[Cindy Winegarden]

Hi Pete,

I didn't realize you didn't have the VFP ODBC driver. It's on the page you
mentioned and the direct link is
http://download.microsoft.com/download/vfoxodbcdriver/Install/6.1/W9XNT4/EN-US/VFPODBC.msi.
Once it's installed you should see "ODBC databases" at the bottom of your
Import list and you will need to create a machine or user data source.