Extracting Quickbooks Data
Posted on 2006-06-29
I need to turn a Quickbooks file into a searchable database file.
In a client's new job, he is required to be able to immediately search his database of previous customers (from Quickbooks 2003 Pro) to avoid a conflict of interest situation. There are 4 fields that need to be extracted from Quickbooks - company name, attorney name, patient name, and date of first invoice. With the new program, he wants the ability to add case names (smith vs. public hospital). Right now there are less than 2000 customer names, but this could soon grow to 20,000 or more.
Does anyone know of an application that will do this? Is there way to convert a Quickbooks file to Access or Excel? Maybe a custom program is the best fit? Any suggestions are appreciated.