User Support Forum

I'm trying to export transaction data from the GL and Contributons details from the contributions module. I want to use a db to do some analysis and can do so if I can get the data into CSV format.

Can you help me with this?

JStegman wrote:I'm trying to export transaction data from the GL and Contributons details from the contributions module. I want to use a db to do some analysis and can do so if I can get the data into CSV format.

Can you help me with this?

Are you trying to do this all in one extract ?? Someone will jump in if I'm wrong, but I don't believe that you can do that directly from PC+ as the two modules really only interact when the contributions module posts to the funds accounting module.

Neil,

No, I would like the transaction in two different tables.

I'm able to import some of the dbf files directly into MS Access but cannot get the transaction detail directly from the dbf files.

So, I would like to export the GL transactions and the CO transactions (separately) to do some further analysis.

I'll take anything I can get, even a printout of the detail.

John

JStegman wrote:Neil,

No, I would like the transaction in two different tables.

I'm able to import some of the dbf files directly into MS Access but cannot get the transaction detail directly from the dbf files.

So, I would like to export the GL transactions and the CO transactions (separately) to do some further analysis.

I'll take anything I can get, even a printout of the detail.

John

You may want to use the Foxpro ODBC driver found on the Microsoft website with Access to pull the data.

Neil,

I've tried a DBF generic reader and it worked for some tables.

I will try the FoxPro idea.

Thanks