>Hi,
>
>I have developed in VFP for a number of years and I'm fairly new to VB and ADO, specifically ADODB.
>
>I'm familiar with the syntax to open recordsets, etc, etc.
>
>With VFP, I'm used to using the REPLACE ALL command in a number of my apps. These are apps in which data is imported from mainframe apps and I was wondering if there is a similiar way to do this using ADO and an ACCESS database?
No there isn't.
You need to execute and SQL query like "Update Table1 set F1 = 'NewValue'". You can execute with the Execute method of the connection object.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com