Connecting Access Database to Oracle Database

[modglin]

I have created an excel spreadsheet that I have tried to link to an Oracle Database without luck. I then pulled it into an Access Database and formatted the GL#, Store# and Date to be the same as the Oracle table. (for GL# - they are both string with 10 length and Store# both string 5 length and date is actually a string 20030101. ) There are three tables from the Oracle database that I need to bring in as well as the Access database. When I link one table to the Access table everything seems fine, it is when I try to link more than one that it tells me that the fields are not the same and that I more that one database driver has been added to the report and not to create any server sided grouping and etc.
Any suggestions on how to get the four tables to link and be able to group and use select records?

 

[modglin]

Forgot to mention - using 8.5 and windows 2000.
The main table has the sales for the month by date by store by product. The Products table gives the GL# for the products on the main table. The Access table has the budgets for each store for each GL#.