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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Item 1
[/TD]
[TD]Item 2
[/TD]
[TD]Item 3
[/TD]
[/TR]
[TR]
[TD]9/1/2019[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[/TR]
[TR]
[TD]10/1/2019[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Item 1
[/TD]
[TD]Item 2
[/TD]
[TD]Item 3
[/TD]
[/TR]
[TR]
[TD]9/1/2019[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[/TR]
[TR]
[TD]10/1/2019[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[TD]$1,594,484[/TD]
[/TR]
</tbody>[/TABLE]
What library do I need to import for Access 2016? Or is that optional?
Thank you!