Import Export data

[John Ralls]

On Feb 3, 2011, at 5:38 AM, bushman wrote:

> 
> Hi folks,
> Am looking at Gnucash to be my new accounting system.
> 
> 1. Are there any plans to provide other exports - e.g. to Excel or Access
> (sorry to use dirty words re non open source software, but have enough on my
> plate learning just this one for now while trying to move forward business
> life).
> 2. I have Access, not MySQL. "Saving as" mysql type would - I understand -
> require a link to existing MySQL software. This is not an Export. Is there a
> file format which could be exported, and which could be picked up by Access?
> 
> 3. An entity relationship model diagram would also be extremely useful to
> everybody, given this is open source, and empower people to much more
> quickly come to grips with the data structure.

1. No.

2. Gnucash supports Postgresql and Sqlite3 as well as MySql. Postgresql is also server-based, but Sqlite3 produces local files and requires no external software. There exist ODBC drivers for Sqlite3 which should enable you to import to M$ Access.

3. I'm working on that, though other tasks have taken priority lately. 

Be sure to read through some of the other threads in this list about accessing Gnucash data via SQL.

Regards,
John Ralls