File is a Microsoft Access database of approximately **3,224** records of company names and contact details.
Clean up of main "Suppliers" table:
* check company names, remove articles from names (ie. "a" or "the")
* lookup companies in [login to view URL] and [login to view URL] and any other online directories and fill in details where possible
* best effort to complete "Status" field, otherwise flag all companies "Active"
* check all fields for consistency: two letter Province/State codes, A#A #A# or ##### postal/zip codes, ###-###-#### format for phone numbers, check email addresses for correct format
Sample of main table attached.