Import - Address Format

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.

Reply to
jdb
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.