View Full Version : Linking QB with MS Access
Has anyone been successful at making an Microsoft Access database application link with data in QB (i.e.: inventory, invoices, etc.)?
11-17-2001, 04:02 PM
Do you want to get data in - data out - or both?
Getting data in is through an IIF file. Read about it in the help file. Getting your head around it takes a while - but once you understand it, it isn't difficult. You write visual basic to take the data from your database and turn it into an IIF file. This goes in through the File / Import / IIF. Intuit is cuurently developing a new method - QBxml which will be in the next US version of QuickBooks. It will use queries to extract and produce data for use with QuickBooks.
Getting data out is a bit more difficult. There is a SDK (software developer's kit) available to developers. Also have a look at "Write it Once" on www.writeitonce.com. They use reports to extract information which is then configured using visual basic so that it can be extracted to an Access database.
If you want to interact with QuickBooks, you have to get the data out, into the Access database, write the transactions, export the information as an IIF and import it into QuickBooks.
All this is being done around the world - but it is not as simple as you would like. (Rocket Science it aint, though).
There's also an ODBC driver for read-only access produced by Hill Croft Technologies at http://www.hcit.co.uk
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.