smartpat19
Board Regular
- Joined
- Sep 3, 2014
- Messages
- 114
I need a excel macro to add records to an access 2016 database. I have tried using multiple sets of code and can't get it to work.
Access 2016 database name: Development Team
Table Name: Costs
*Headers are the same on access and excel*
Excel sheet:
Tab: Temp
<tbody>
</tbody>
What library do I need to import for Access 2016? Or is that optional?
Thank you!
Access 2016 database name: Development Team
Table Name: Costs
*Headers are the same on access and excel*
Excel sheet:
Tab: Temp
Date | Item 1 | Item 2 | Item 3 |
9/1/2019 | $1,594,484 | $1,594,484 | $1,594,484 |
10/1/2019 | $1,594,484 | $1,594,484 | $1,594,484 |
<tbody>
</tbody>
What library do I need to import for Access 2016? Or is that optional?
Thank you!