Hello everybody,
I got some wonderfull code here on this Forum to connect Excel to Access and vice versa. It works fine, so I can send data from Excel to an access.mdb file to append it. It uses the
Dim rs As New ADODB.Recordset '// you can use As Object for the late binding
Dim SQLstr As String
On Error GoTo Err_Control
Set cnn = CreateObject("ADODB.Connection")
SQLstr = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & dbPath & ";" & _
"Jet OLEDB:Engine Type=4"
cnn.Open SQLstr
as connection.
So far so good, but i can't write to older versions off Access with that driver, so my question for today is, is there simply another driver i can use to connect to that type of mdb file??
Thanks in Advance
Bernd