Addnew vs. Insert Into

[KenSquare]

I worked on a program a few years ago that takes data from a series of text files and loads an Access database. I added to the code from a program started by someone else, so I did not write the imports and declarations. They used an ADODB.recordset, addnew and recordset update to move the data into the table. My contribution was to extract information from some additional text files to send to the database. Here are the initial lines from the original program, which I tried to copy:

  Imports System.IO
    Imports System.Data.OleDb
    Imports System.Text.RegularExpressions

        Dim streamText As StreamReader
        Dim con As New ADODB.Connection
        Dim rstInput As ADODB.Recordset

I needed to write a similar program from scratch, imported the same system.data.oledb, but when I declare the connection and record set, I get the blue underline and "connection not defined" error. It appears to me that I am defining everything the same way as it was in the original program.

I worked around this by building an Insert Into statement, and that works.

I have 2 questions:

• How do I correctly create an ADODB connection and recordset?
• Is there an advantage to filling a record set with Addnew over an Insert Into?

Thanks for any help you can offer!

[Reverend Jim]

You have to add adodb to the project.

Project -> Add Reference
.NET tab
Sort by component name
select adodb

[KenSquare]

Thanks Reverend Jim!