如何从 QuickBook(.qbw) 文件中查询一些数据? [英] How to query some data out of a QuickBook(.qbw) file?

问题描述

• 我是 QuickBooks 世界的新手.
• 我有一个 .qbw 文件 -> CompanyName.qbw
• 这是一个巨大的文件，几乎包含了我公司的所有信息.
• 我想从该文件中查询 some 数据 - 不是全部，而是一些.:)

• I am new to the QuickBooks world.
• I have a .qbw file -> CompanyName.qbw
• It's a huge file that contain almost everything about my company.
• I want to query some data out of that file - NOT all , but some.:)

比方说，我只想查询inventory report.

• 在该库存报告中，我只需要 3 个字段.

• Within that inventory report, I only want 3 fields.

1. product_id
2. 姓名
3. 可用性

我一直在到处寻找工具，但找不到任何可以完全满足我的要求的工具.

I've been looking for a tool out there everywhere, I could not find anything that will does exactly what I want.

有人可以让我开始吗?任何人都可以至少指出我正确的方向吗?

Can someone get me start on this ? Can anybody at least point me to the right direction ?

我不太确定，如果我想要做的事情是可能的.

I am not exactly sure, if what I am trying to do is possible.

推荐答案

不是直接回答，而是按照您的要求提供一些指导:

Not a direct answer, but some direction as you requested:

此处提供的 QOBDC 驱动程序 (http://qodbc.com) 应该允许您像访问SQL 数据库并对其执行查询.有一个免费试用版，但如果您发现该驱动程序有效并希望长期使用它，您似乎需要支付 150-500 美元才能购买该驱动程序.

The QOBDC driver available here (http://qodbc.com) should allow you to access your qbw file like a SQL database and perform queries against it. There is a free trial, but it looks like you'll need to pay $150-$500 to buy this driver if you find that it works and you want to use it long term.

至于查询特定报告(如库存)，我不知道，但是有大量博客文章和 YouTube 视频形式的教程可以帮助您了解如何将 QODBC 用于您的目的.

As for querying a specific report like inventory, I don't know, but there are plenty of tutorials around in the form of blog posts and YouTube videos that should help you figure out how to use QODBC for your purpose.

这篇关于如何从 QuickBook(.qbw) 文件中查询一些数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！