Help with registering control using VB.NET

Hi,

I am using the code below to transfer data from an excel file to a dataset, but receiving error message: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
on line:
conn.Open()

How do I register the 'Microsoft.ACE.OLEDB.12.0' provider?

Private Function makeDataTableFromSheetName() As DataSet
        Dim ds As DataSet = New DataSet()
        Dim DestinationPath As String = IO.Path.Combine(Application.StartupPath + "\AOP40SC1.xls")

               Dim Conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; " & "data source='" & DestinationPath & "';" & "Extended Properties=""Excel 12.0;HDR=YES;IMEX=1"" ")

      

        ' conn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; " & "data source='" & DestinationPath & "';" & "Extended Properties=""Excel 12.0;HDR=YES;IMEX=1"" ")
        '      
        conn.Open()

        Dim dt As New DataTable()
        adap = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", conn)
        adap.Fill(dt)
        ds.Tables.Add(dt)

        conn.Close()
        Return ds

Select allOpen in new window

Thanks,
Victor