Export Excel Data to Access table

Hi Champs,

I have a xlsx file

Excel with dynamic data

I need a Access database macro (i need to run it from Access). should ask me to browse excel file and export xlsx row values to access table (any name for table . eg: data)also next day when i browse another xlsx, the data should append to last used row in the access table. pls help

you dont have to export XL to access.
in Access, create a linked table to the access table. (an external linked table)
the table updates when you update the XL file.

if you need, run any queries against the xl table.

Yes Agree.. But i will be receiving n number if xlsx per day from various vendors.... with same header names... i just need to browse and append the data...pls help