[RESOLVED] Problem reading excel file using ADO!

[Paco75]

Hi,

I tried to read a excel file using the method i found here http://www.xtremevbtalk.com/showthread.php?t=217783

But i get an error on ADODB.Connection saying "Type 'ADODB.Connection' is not defined" in the following code:

Private Function GetExcelConnection(ByVal Path As String, _
    Optional ByVal Headers As Boolean = True) As Connection
    Dim strConn As String
    Dim objConn As ADODB.Connection
    Set objConn = New ADODB.Connection
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
              "Data Source=" & Path & ";" & _
              "Extended Properties=""Excel 8.0;HDR=" & _
              IIf(Headers, "Yes", "No") & """"
    objConn.Open strConn
    Set GetExcelConnection = objConn
End Function

It was used in VB6... do i need to do something special in Visual Studio 2010? What is wrong in this code?

thanks

[Paco75]

Anyone know what to do? Seems to be a simple declaration or define ADODB object in my project but i dont know how to do it in Visual Studio 2010! I have not used VB since VB6... im a bit lost lol.

[Paco75]

Never mind i found it. It was simply Project->Add Reference. Then choose "Microsoft ActiveX Data Objects 2.8 Library" (latest one)