Excel in Access - Problem & Solution!
One of the most frequent problems I see is people confusing MS Access with Microsoft Excel. This leads to fundamental design errors. Now, the problem is, this error “A Major Error” does not become apparent straight away. Unfortunately your database will work quite happily built in this erroneous manner… That is, until you need to extract useful information from it.. You have this marvellous database which you have spent many hours constructing and then all of a sudden it becomes very difficult to take your next step.
In this Blog I address the problem. I demonstrate an easy solution so you don’t have to go all the way back to basics. In many cases you will be able to manipulate your existing MS Excel sheets and convert them straight into a suitable format for MS Access. Alternatively you can convert data you have imported from MS Excel to MS Access in the same way… This is a ” ~ SERIOUS ISSUE ~ “ for People moving from Excel to MS Access, I suspect 9 out of 10 people make this mistake and it cost them many hours, possibly days to sort out the problem.
In summary, the problem is the assumption that an Excel layout will transfer directly into an MS Access table. The problem is, it does! However, that’s the Beginning’s of your problems. The solution is to follow some simple design rules which I explain in detail – See links below…
The Problem & Solution!
Excel in Access
Video 1 (6:24)
Video 1 (6:24)