如何使用Excel VBA获取新插入记录的ID？

Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this regard however).Seems a common enough problem this, but most so