How to export data from VFP with SQL backend database to QuickBooks

woodwyn
woodwyn used Ask the Experts™
on
I have a client asking about their VFP app being able to export data to QuickBooks.  I am wondering if anyone has suggestions on how to best go about making that work, using 3rd party tools or otherwise?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
I suggest you consider QODBC for QuickBooks as the connector to your database

https://qodbc.com/what-is-qodbc/

This is the most well known connector.
Olaf DoschkeSoftware Developer

Commented:
What do you mean with SQL backend? A DBC or an MS SQL Server backend?

The transfer of data to another database could also be handled with Export/import assistants of SQL Server Management Studio.
It's not the topic to migrate the full backend, right? Only export Quickbook relevant content. Sure that'll be possible, as long as Quickbooks has an ODBC connector.

Quickbooks is solely about finance, right? Quite sure the connection problem is simple to solve, but if a VFP app has no idea about the structure of the Quickbook backend it's not simply connecting and clicking "export".

Sounds to me like a feature that would need to be implemented in that application, if the application backend and features don't suffice. Also without further information about the Foxpro app backend and nature and available data and what exactly should be exported it's impossible to make tell what's possible or estimate the necessary work.

But they should know that if it is, as you say, their app. Is it developed by them or is it an ERP they bought? In the latter case, the should ask the vendor, not just any FoxPro consultant. And you should also know yourself that FoxPro knowledge only is the basis for picking up the project and extend it. But Foxpro is just a programming language, no ERP of which you could ask about ERP features. How should we know what's possible with this app?

Bye, Olaf.

Author

Commented:
Thank you.  The clients finance team is weighing their options.  The details are that they are using a VFP app with a MS SQL backend to manage most of their business and QB to manage the accounting.  We will be exporting time, materials and invoicing information to QB from the VFP app or using SQL.  It sounds like we will use QODBC and modifications to the VFP app to make this as simple as possible for the users.  More to come, but I will assign points now.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
QOBDC should work for you as it is a solid product.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Thank you and I was happy to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial