Excel Table - How to Append to Access Database Using VBA

[mark2323]

I have an Excel Sheet that holds a Table (Table named "PST_2" ) that I need to append to an Access Database (DB named "STATS.accdb"). I need to do this while the user has Excel open, and without opening the Access application, as some users may not have it. I know how to initiate appending from Excel to Access while using Access. But I'm having trouble finding clear info online of how to initiate the opposite direction with a macro/VBA from within Excel, without the user having to open Access.

Here are the filenames and paths:

Excel File Name: TDCD_GAME.xlsm
Excel File Path: C:\\TDCB\TDCB_GAME.xlsm
Excel Sheet: PSTLD
Excel Table: Named PST_2, actual range on PSTLD sheet will vary as it's dynamic
Access File Name: Stats.accdb
Access File Path: C:\\TDCB\Stats\stats.accdb
Access DB Table to Append: PST

* All headers in both the Excel Table ("PSTLD") and Access Table ("PST") match exactly *

Any input would be greatly appreciated!

 

[Micron]

Perhaps look here...

EXCEL Import And Export

I do not know for sure if any Excel sub run by an Excel user can push data to Access, but I think so. It ought to be the application that moves the data to Access, and AFAIK, the Excel user does not have to have Access installed.