I need to import data from Access to Quick Books. The invoice data from an MS Access database and the Customer data. The a predefined database structure import the invoice (Sales Contract), Invoice Details (Transaction Details) into a Quick Books 2002 Pro Estimate. When New Custoimers are added this data also needs to be imported into Quick Books. The initial data set will be produced in a query and written to a MS Access temp table. This is for ease of support by the end user. This is done via an attached table to an instance of MS SQL Server. Once the result set is produced the data should then be imported into a Quick Books Estimate. In addition When new Customers are added the data from Quick Books should be passed to populate the Quick Books Customer table. The end product should consist of a form with a button that displays the record set that was produced and a button that executes the import into Quick Books. One Button for The Sales Contracts to be imported into the Estimates and another button to import the new customers. This can be a stand alone application thatexecutes against the database.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Windows 2000 Server Visual Basic 6.0 MS Access SQL Server 2000 Quick Books Pro 2002