Found the problem.
The csv file (dest.csv) was being generated with (,) spearating the values and not with (.
This prevented the ADODB object from reading the field names from dest.csv.
I added a function to convert (,) to ( in the dest.csv file after it being generated.
I leave it here, just in case someone else needs it:
Sub CommaReplace
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForReading)
strText = objFile.ReadAll
objFile.Close
strNewText = Replace(strText, ",", ";")
Set objFile = objFSO.OpenTextFile("C:\Inetpub\Admin\dest.csv", ForWriting)
objFile.WriteLine strNewText
objFile.Close
End Sub
Thanks everybody.