Trying to insert data from Excel to Access, but having issues with the resources... If I run the code below, I get an error saying "
Compile error: User-defined type not defined" This at the line wher I set the conn variable... Which resource do I need to make this work?
Dim SqlStr As String
Dim conn As Database
Set conn = New ADODB.Connection
.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False"