Hi!

oConnection = CreateObject("adodb.connection")
With oConnection
   .Provider = "MSDASQL.1"
   .ConnectionString = "Persist Security Info=False;Data Source=your_DSN_here"
   .Open
EndWith
oRecordSet = CreateObject("adodb.recordset")
With oRecordSet
   .Open("Select * From Customer",oConnection)
   .MoveFirst
   .Fields("CustName").Value = "ABCDEF"
   .Update
EndWith

Also take a look on article "ADO Jumpstart for Microsoft Visual FoxPro Developers" in MSDN->Technical Articles->Visual Tools->Visual FoxPro,
and "Q165492 - HOWTO: Use ADO with a Visual Foxpro Database".

>Hi all,
>when trying to update records in a table, I get an undefined error like command too long.
>I'm using FoxPro 6, ADO 2.6 and tables in a DBC.
>The table I try to update has 128 columns.
>Can somebody provide me with a connection string and recordset definition that let me select a record in the recordset, write a value to a record column and then update the recordset to the table?