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?