Easy way to compare table from excel

[Stacy Rueda]

Hi

Good Day.

Can someone please help me regarding table in Access. I have data from excel which I imported to Access. Can you have an easy way to compare two data which is duplicate names but different quantity.
Example below.

EXCE1	EXCEL2	EXCEL1.QTY	EXCEL2.QTY
APPLE	APPLE	8	10
APPLE	APPLE	10	8
BANANA	BANANA	6	3
BANANA	BANANA	3	6
CHERRY	CHERRY	2	3
CHERRY	CHERRY	3	2

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I am checking this manually by moving my eyes up and down.lols. Guys can you help me on how to import to Access that automatically fit on the quantity from Excel 1 and 2. Thank you so much

 

[james_lankford]

select 
  tbl_1.EXCE1, 
  tbl_1.QTY,
  tbl_2.QTY 
from 
  EXCEL1 as tbl_1 
  inner join 
  EXCEL2 as tbl_2 
    on 
    tbl_1.EXCE1 = tbl_2.EXCE2

 

[Stacy Rueda]

hi, thank you for your reply.

where can I execute the code? I'm just using compare table and is it possible to put code in query table so it automatically match on the quantity even items are duplicate?