I need a vba macro that will import list into a Access 2010 database.
The applications will need to automatatically detect what kind of info is in each column and organize it into the database format depending on a keyword table.
The expected format will be : name, address, city, postal code, province, phone #, website.
The application would decide to place any keyword equivalent to name (business name, company, business, etc.) into position 1.
Would need also a form that pop-up when unknown keyword is processed.
I need that code ASAP and with a lot of comment to maintain it.