I have a situation here..
i have one excel file which consist of 3 sheets...
i want to read the excel file starting from sheet 1, line by line...
i also have one table in access which act like a comparison for the excel sheet..
i want to read from the sheet line per line, every line will be compared to the table in ms access and after being compared it will store to another table...
i can do if the file is comma delimeted csv or txt file but this is an Excel file.
i attach the file here so anyone can see what i'm trying to do.
thanks in advanced.
