Create new customer in Quickbooks

[mkaeser]

Hello all,

Looking for a way to fully integrate MS Access 2007/2010 with Quickbooks Enterprise Solutions. And I mean, fully integrate. It seems like most options I have found are import/export drivers with the occasional perk, but they all seem to lack something import.

Currently, I am trying to find a way to automatically enter a new customer, and create an invoice. Looking up the QODBC, it seems simple enough to generate the invoice BUT the big gotcha is the customer needs to be in quickbooks for this the work. So it seems I can do an import from Excel to Quickbooks to create this new customer, but is there a way to do this with VBA? Is there any way for MS Access to tell quickbooks to import a specific excel file, or am I reaching too far? Thank you!

 

[mkaeser]

I have come across a program from bay state consulting that will import the excel list to the customer list in quickbooks. It also seems like you can automate this process by either using command line or the windows scheduler. So it IS possible to do what I wanted, I am just wondering if it's necessary to purchase an import program or if I can import an excel into quickbooks another way. Thanks!