Hi,

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?

Thank you

    Dim SqlStr As String
    Dim conn As Database

    Set conn = New ADODB.Connection
    With conn
        .Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False"
        .Execute (SqlStr)
    End With

Hi

Change

 Dim conn As Database to
 Dim conn As ADODB.Connection

and make sure you have included the Microsoft Data Objects 2.7 (ir whatever) library in the reference


Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)