Accessing data using MSAccess

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Accessing data using MSAccess

Postby najlaa » 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.
najlaa
 
Posts: 6
Joined: Fri Jan 16, 2004 10:21 am
Location: New York

Postby Zeb » Fri Jan 16, 2004 11:18 am

Here is an article discussing alternative methods to access the database files.

Also, although this document is not created or supported by PowerChurch in any way, HERE is an article detailing the whole process. The only difference is when you select the Visual Foxpro file using browse, version 8 and 8.5 does not use the DBC, it uses Free Tables.

Good Luck!

Image
Zeb
Tech Support
Tech Support
 
Posts: 116
Joined: Tue Sep 02, 2003 11:43 am
Location: PowerChurch Software

Postby Zaphod » Fri Jan 16, 2004 11:27 am

We do not recommend, nor can we offer support for updating/deleting data external to PowerChurch. You can connect to the PowerChurch data using the Foxpro ODBC driver available from Microsoft, but we suggest using that access for READ ONLY.

Make plenty of backups, because if you wreck your data, you're on your own. Actually, you're on your own either way.

PowerChurch Software Technical Support
(800) 486-1800
http://www.powerchurch.com/
Zaphod
Program Development
Program Development
 
Posts: 828
Joined: Tue Sep 02, 2003 11:48 am
Location: PowerChurch Software