Quickbooks Conversion from Access Database

Eileen Murphy
Eileen Murphy used Ask the Experts™
on
Hey Experts! I have successfully connected an Access db to Quickbooks and have been able to transfer list data (items, terms, etc.) but am having problems with Customers and Vendors.

My client has a 1 to many table of ship-to's and I can't seem to get those in. It looks like the Quickbooks import function has 4 ship-to's in the spreadsheet format they require we use.

I am looking for someone to help me with this project if possible.

Thanks in advance for any help you can provide.

Best, Eileen
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
What are you using to connect to the Access database? There are many different methods you can use for this (QODBC is probably the most popular).
Eileen MurphyIndependent Application Developer

Author

Commented:
I am using QODBC -- but some things just aren't coming over correctly. I am working with Quickbooks/Intuit technical team on this right now. I'll see how that goes and then post the results.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
<My client has a 1 to many table of ship-to's and I can't seem to get those in. It looks like the Quickbooks import function has 4 ship-to's in the spreadsheet format they require we use.>
It is not clear what this means in terms of Access or Quickbooks...

Can you post a generic sample of this output, with a few 1 to many records...
Commented:
The only way I know to import multiple ship-to's into a file is through .iif and even then it takes a few extra steps. There is no table that the SDK/ODBC  give access to that holds multiple ship-to's.

This is how you have to do it with .iif.: http://community.intuit.com/posts/importing-customer-multi-location-addresses

With that idea in mind, you might try importing the customers then making a second pass with each address set up as a job under that customer. I'm sure you'd still have to delete the jobs but might be worth it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial