RE: QuickBooks to SQL Server – SQLServerCentral

SSC Guru

Points: 323504

June 27, 2012 at 6:10 am

i had used the quickbooks driver from http://www.rssbus.com/ado/quickbooks/ so i could connect via a .NET application;

They had a decent amount of examples, and it was pretty easy to connect and view the data; from there, i could put the data in a datatable in .NET, and do what i want with it after that, for example copy all the tables to SQL server for example.

When i did that is was the version 1.0 driver, and it did work well, but one specific thing that i was looking for, which was the Relations/ Foreign key equivilent for Payments Received-to-Invoices-Paid was not exposed; That was a critical piece for the process I was building, so I stopped investigating that.

Their driver is now labeled 2.0, but it was definteily straight forward if you are a programmer.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!