Apache OpenOffice Community Forum

Quickbooks allows me to export reports to Excel. Does anybody know if there's a way to get it to export to OpenOffice instead of Excel? Thanks, Katherine

OPenOffice.org Calc can read Excel files.

See also that query.

Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

NB: topic moved to the Calc section.

Calc will not import Quickbook's Excel export because Calc refuses to operate the macros built into the Excel sheet. I've tried turning off Calc macro security and it still won't import. If anyone else knows of a work-around or a way to create an environment to run it in, I would be ecstatic. In the interim I continue to modify the .CSV export... BTW I'm now running OO 4.0 on Win7 Pro 64-bit

Are you telling us that QB exports its data in VBA modules?

http://www.qodbc.com/default.htm is a solution to export from the QB database to any ODBC capable application (such as AOO)

Villeroy, my apologies, while moderately tech savvy, I don't know what VBA module stands for. I can say, though, that the export function/package/module opens Excel and allow user to choose data range to import, will manipulate data, and can call a different data range. The issue with Calc arises with the inability to get it to run the macros. It opens Calc and responds that security needs to allow the macros to run. Even with the lowest security option to allow all macros to run, the same message displays. Frustrating. The ODBC package you mention appears to be a report generation package. I would prefer to use what they already provide and not have to build my own reports. Sigh...

Thank you for the clarification. I did not imagine how crazy this data export is organized. Now it would be interesting to see the VBA code which surely utilizes the ODBC driver to dump the report data into spreadsheets.
You can not blame OpenOffice that Intuit developers write code which is understood by Excel and nothing but Excel.

Oh, goodness, Villeroy, I wouldn't blame OpenOffice! Intuit's designers are bound by their company's proprietary relationship to MS, as most common-use vendors are. Believe me, if our kitchen design package would easily run on Unix, I would have bid Windows a fond fare-thee-well long ago. Sorry, not very on point. I was hoping someone smarter than I had faced this and created a work-around or maybe a patch that would create an environment in which Calc could open the macros. Alas, it is manually editing the .CVS file for me.

As an aside, I believe I will post a similar request on Quickbooks' user BB and see if I get any bites there. I will advise if I have success and supply the gory details.

There is an ODBC driver for QB.
There is a database component in AOO which is designed to connect this office suite to databases.
The problem is that virtually nobody is seriously interested in developing any solution.
Everybody nags someone else for a perfect solution which is always a claim like:
"Do exactly the same as Excel does"
or
"Make this program an 100% Excel clone for any 3rd-party software calling Excel".
Technologies do not work like this. Nobody will turn this software into a cloned Gigabyte monster and MS lives very well from being incompatible with the rest of the world. This used to be their business model. There is already a program which behaves exactly like Excel. If you can't afford it then you don't need financial software neither.

Office 365 when exporting it.