VBA macro to open Access database and copy top row of table including headers

[kthorson16]

I am looking for some help in creating a VBA macro in excel 2010 that will open an access database table titled "RX", copy the first row of data including the headers and paste the row of data into row A5 in the excel workbook that is executing the macro.

Title of Access Database: RXtest.mdb
Title of table in Access database: RX
Title of the tab in excel to place data: RX validation
location of access database: H:\VBADatabase
Name of Excel File: Data Validation.xlsm