How to import email addresses into Quickbooks Vendor File
One of our customers would like to associate email addresses with the vendors they have in Quickbooks 2018.
Many years ago we developed an MS Access application to handle some of the core business functions. The Accesss DB also has most of the same vendors in the QB application. However, vendors in the Access application already have email addresses entered.
It would be very convenient to create an export of the email addresses from our Access application, which could then be imported into Quickbooks.
I know how to create export files from our application and they can be created in many different formats. I have no knowledge of Quickbooks though.
In what format and with what contents/fields would the export files have to be created to be imported into the Quickbooks vendor file?
On the Quickbooks side: What would be the steps to import the file containing the email addresses?
Many years ago we developed an MS Access application to handle some of the core business functions. The Accesss DB also has most of the same vendors in the QB application. However, vendors in the Access application already have email addresses entered.
It would be very convenient to create an export of the email addresses from our Access application, which could then be imported into Quickbooks.
I know how to create export files from our application and they can be created in many different formats. I have no knowledge of Quickbooks though.
In what format and with what contents/fields would the export files have to be created to be imported into the Quickbooks vendor file?
On the Quickbooks side: What would be the steps to import the file containing the email addresses?
ASKER
This is for sure a one time thing but thanks for your input.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For automation from ODBC applications, though, you can't beat QODBC. However, the pricing may be too high for a one time thing like this, as the 30 day evaluation supports only 20 updates per session. If you had numerous ways you could use it, though, it is well worth the money. I use it myself for integration with a web storefront and for automating the invoicing process.