ADO to write records in MS Access

sirpete
sirpete Member Posts: 15
I have a rookie question / request.

Can anyone post some sample code to create new records in an Access 2003 database using ADO? I've managed to get the connection open and can read records (using the External Databased via ADO Example download from here) but I have no idea how to write the data.

Comments

  • Waldo
    Waldo Member Posts: 3,412
    Isn't it just sending "INSERT" statements.

    I wrote this once about ADO on my blog. It's not Access and not writing data, but may be it can by of any help ... :| .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog