I need to import ~500 customers into QB from Microsoft Access.
I exported the Access file to Excel, then imported the excel file.
I mapped the fields as follows:
maAddress1 = qbAddress1 maAddress2 = qbAddress2 maCity = qbAddress3 maState = qbAddress4 maZip = qbAdddress5
The import worked fine, except the address are screwed. When I write a check, each address field is on a separate line, and blank lines are not suppressed.
How can I format the addresses so that they print on checks in the usual way (i.e., blank lines suppressed, City, State Zip on one line)?
Thank you for your help.