How do you grab data in a Microsoft access table using ADO in VBA? I am trying to grab a person's first name out of a field that contains a person's full name and put it in a new field. I am a little hazy(unsure) on how to do this in VBA. I a little familiar with ADO in general, but would not call myself an expert(hence, my question). Thank you.