Starting from Excel structures for creating a database structure is not the best of ideas. Relational databases work differently: they keep all data...
Consolidating numerous Excel worksheets into a unified database is my current task. Although I'm not particularly knowledgeable about Access, I excel...