The verdict in three sentences
Operations running on an ageing Access database and Excel files passed around by email cost money every year in re-keying, errors and the risk of total loss. A migration to a web application costs USD 60,000 to 180,000 in New York, takes 3 to 5 months and requires a separately budgeted data migration. Method matters as much as budget: inventory, cleanup, phased migration and a short parallel run.
Risks of the current setup and the cost of doing nothing
Many mid-sized companies in distribution, freight forwarding, wholesale or services still run on an Access database built over 15 years ago by a long-gone contractor, topped up with Excel workbooks copied from desktop to desktop.
| Current risk | Observed frequency | Estimated cost (2026 ballpark) |
|---|---|---|
| Loss or corruption of the Access file | 1 incident every 2 to 3 years | 3 to 10 days of reconstruction, plus lost data |
| Competing versions of Excel files | daily | 30 to 60 minutes of reconciliation per user per day |
| Invoicing errors from re-keying | 0.5 to 2% of invoices | 0.3 to 1% of revenue |
| No access from a branch or on the road | permanent | delayed decisions, trips to head office |
| No automatic backup | common | full exposure to theft or workstation failure |
| Dependency on the one person who knows the database | common | blocked if they leave or fall ill |
| Outdated Windows and Office | common | security holes, incompatibilities |
What the migration costs in New York in 2026
| Item | Range | Detail |
|---|---|---|
| Audit of the existing system and specification | USD 5,000 to 15,000 | inventory of tables, queries, macros and files |
| Web application development | USD 60,000 to 180,000 | by module: sales, inventory, purchasing, invoicing, reporting |
| Data migration and cleanup | USD 8,000 to 25,000 | duplicates, date formats, inconsistent customer codes |
| User training | USD 3,000 to 8,000 | 2 to 4 sessions per profile |
| Cloud hosting and backups | USD 150 to 600 per month | daily backups, multi-site access |
| Annual maintenance | 15 to 20% of development | fixes, security, small enhancements |
| Total timeline | 3 to 5 months | including 2 to 4 weeks of parallel run |
The same project delivered from Dakar or Lomé by a nearshore team typically costs 40 to 60% less, with overlapping working hours in the morning New York time.
The five-step method
- Inventory: list every Access table, query and Excel file, with its owner and how often it is used. You often discover that 30% of files are no longer used.
- Cleanup: deduplicate customers and products, normalise codes, set a cut-off date for migrated history.
- Phased development: start with the most painful module, often invoicing or inventory, deliverable in 6 to 8 weeks.
- Migration and parallel run: 2 to 4 weeks during which the old database stays available read-only.
- Archiving: keep a frozen copy of the Access database and files for record-keeping obligations (7 years is common for US tax records).
Mini case study
Angela is finance director of a 45-employee wholesale distributor in New York, with a warehouse in New Jersey. Six people spend about 1 hour a day reconciling Excel files and re-keying into Access: 6 × 230 days = 1,380 hours a year, or USD 62,100 at a loaded cost of USD 45 an hour. The migration is quoted at USD 110,000, plus USD 15,000 for data migration, with maintenance at USD 16,500 a year. Net annual gain: 62,100 - 16,500 = USD 45,600. Payback: 125,000 / 45,600, about 33 months, not counting avoided invoicing errors or the New Jersey warehouse finally connected in real time.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Can we keep Access running alongside after the migration?
Yes, read-only for 2 to 4 weeks, then archived. Beyond that, a parallel run recreates exactly the inconsistencies the migration was meant to remove.
Must all historical data be migrated?
No: usually 3 to 5 years of active history is migrated and the rest archived. That cuts data migration cost by 30 to 50%.
Will the app work on an unstable connection?
A well-built application weighs a few hundred KB per screen and can offer offline data entry. For field staff, a mobile-friendly interface avoids needing a laptop at all.
How long does team training take?
Allow 2 to 4 sessions of 2 hours per profile. Excel users usually adapt to a well-designed web interface within 2 weeks.
What happens to VBA macros?
They are analysed one by one: most become automatic business rules in the application. The most complex ones often account for 20 to 30% of development time.
Let's scope your project. We audit your Access database and Excel files, price a phased migration and data takeover, with a realistic cutover plan. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
