Excel File Export in to a table

[Beginner613]

Hi All!
I have a file in excel that we are getting on the daily basis. I want to create form in access with the button that when I will be clicking on this button it will export the excel file in to the table.

Thank you,
B

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Beginner613]

Thank you so much! Really helped. But now I have another issue. I am exporting the excel file to one table. But then when I receive another excel file I want to export it to another table...and then compare differences between both of them...

I know how to export 1st excel and 2nd as well. But how should I compare two tables? What is the code that by click of the button it would work and would spit the results.....