Is it a DSN less connection? If yes then try with DSN.

I just modified the string for better readability...

strsql = "INSERT INTO Lat (1,2) VALUES ('" & _
.TextMatrix(i, 1) & "','" & _
.TextMatrix(i, 2) & "')"