AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
I find this works for me within Access
Code:
But I'm trying to send this from Access to Excel via ADO connection and can't figure out the sql for addressing the columns in Excel.
I have a working connection wand a recordset open so I'm close !
Code:
Code:
UPDATE Table1 SET Table1.d = "wow" WHERE (((Table1.Field1)="ThisRow"));
I have a working connection wand a recordset open so I'm close !