If you are interested in getting started with Access, then here is a link to a basic tutorial by one of the MS MVPs, Crystal Long.

Access Basics

With the issue you have, this may be the right time to start learning Access as it can be a great help with Excel analystics.

Alan

BTW: MSQuery wants to see tables laid out in a table format. See if change your data to an Excel "table" using the Excel wizard helps. Without seeing your data, it will be difficult to diagnose this further.