What ADO connection string do i use when reading-in text file

Hi,

I am trying to learn more about using ADO to readin text files. One of the first questions i have is what connection string do i use?

In some things i have read do something like this:

Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
        "Data Source=" & Input_FolderPath & ";" & _
        "Extended Properties=Text;"

In other places i have read do something like this:

Set cn = CreateObject("ADODB.Connection")
strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
    strPath & ";Extended Properties=""text;HDR=Yes;FMT=Delimited"";"

I have no idea what OLEDB.12.0 is or what OLEDB.4.0 is......i dont even know if one of these is what i should use...........

Any ideas on this?