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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
QOBDC should work for you as it is a solid product.
Thank you and I was happy to help.
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.