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

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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
I suggest you consider QODBC for QuickBooks as the connector to your database

This is the most well known connector.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Olaf DoschkeSoftware DeveloperCommented:
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.
woodwynAuthor 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)Commented:
QOBDC should work for you as it is a solid product.
JohnBusiness Consultant (Owner)Commented:
Thank you and I was happy to help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.