Excel in Access

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.