Hi everyone, i`m trying to make access interact with excel in vba
I have an excel sheet with 3 columns and 30 rows, and an access table of 4000 rows.
The idea is to compare every row of the excel from only one column with every row of my access table from only one column of the same type.
For examle:
My excel has 3 columns: Code, Name, City.
My access table has 4 columns: Code, Name, City, Country.
I want to compare every "Code" of my excel, with every "Code" of my access to find the matches IN ACCESS.
If any could help me with this I would be very very pleased!!