Accessing data using MSAccess
Posted: Fri Jan 16, 2004 10:50 am
We have been using PowerChurch for a few years now and as such there is a need for us to do some data clean up. I would like to access the PC data and scrub it to clean it up a bit. I was told that I could use MSAccess and link to data using the Link table feature, but when I tried, I got an error stating it was not in database format. I have the latest Foxpro driver from MS, I know that is not the problem. Since accessing PC data is not supported by PC, I was wondering if anyone had step by step directions to connecting to the data using MSAccess. Otherwise, does anyone have any other suggestions on data cleanup besides perusing through thousands of individual records and making corrections manually.