Syntax error for creating database connection

[yxz152830]

archmaesters, the connection line went wrong, how do I correct it? Thanks connection1.Open: "provider= microsoft.jet.oledb.4.0; extended properties= excel.8.0; data source=" & ThisWorkbook.path & "/database/exceldata.xls"

Sub adddata()
Dim connection1 As New ADODB.Connection
Dim command1 As String
connection1.Open: "provider= microsoft.jet.oledb.4.0; extended properties= excel.8.0; data source=" & ThisWorkbook.path & "/database/exceldata.xls"
sql = " insert into [sheet1$] (name, age, gender)  values('jesus', 27, 'male')"

connection1.Execute sql
connection1.Close
Set Connection = Nothing
End Sub

 

[RoryA]

Remove the colon after Open

 

[yxz152830]

Remove the colon after Open

Could not find installable ISAM. ugh this is overwhelming

 

[RoryA]

If you're using 365 you should probably be using Microsoft.ACE.OLEDB.12.0 rather than microsoft.jet.oledb.4.0

 

[yxz152830]

If you're using 365 you should probably be using Microsoft.ACE.OLEDB.12.0 rather than microsoft.jet.oledb.4.0

just tried not working and the tutorial saved this in classmodule. It works

Property Get database12()
database12 = "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.path & "/Database/exceldata.xls"
End Property

 

[yxz152830]

just tried not working and the tutorial saved this in classmodule. It works

Property Get database12()
database12 = "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.path & "/Database/exceldata.xls"
End Property

nvm i copied pasted it and works again i think it's just a tiny syntax error somewhere