Using Access to edit a Visual Fox Pro database
Posted on 2005-04-13
Hi fellow experts! DB's aren't my forté, so here goes:
I'm on a long term project at a client setting up and entering the data into a program called Advisor's Assistant.
Advisor's Assistant uses Visual Fox Pro (I determined this from occasional errors like "Error: Cannot Exit Visual Fox Pro"). AA's interface although fine for day to day updates, is pretty lacking for initial data conversion (most of our client data is now in Excel spreadsheets).
We do not have Visual Fox Pro installed, just the engine that AA uses.
We do have Access 2003. In the past, I've often found it easier to work directly with Access's tables instead of using whatever "Input Forms" others had created...especially when making hundreds of identical changes to different records (like changing all the instances of "purple" in Field <x> to "violet", or when adding a new field and giving the first 300 records one value, the next 400 or so another, etc...just pasting the appropriate vales into the cells)
I would like to do the same kind of thing here, since I need to enter hundreds of the same value to certain fields after doing an import from .cvs into AA (their import process is limited in what fields can be populated). I never used Visual Fox Pro, and am not familiar with it's file structure. Can anyone give me ponters as to how to open the VFP db in Access? Is there a plug-in that would allow this, can Access do it natively, or do I just have a case of wishful thinking?