Tasks in Access DB from VBA in a Excel spreadsheet

I need to do some tasks in an Access DB from the VBA in Excel. I need to insert new data, replace data, add new columns of data, replace columns of data. I also need to get data from the Access DB to other Excel spreadsheet. I need a VBA code in Excel to get the last n rows of the table (for example, last 300 rows/more recents dates) or get n rows of only some columns of the table.
I need a good code to to it fast, avoiding using some slow loops.