Hi all,

How can i access Excel file using ADO;
Am i right to open a connection?

Dim cn As New ADODB.Connection
Dim strcn As String
strcn = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=N:\Reject_May.xls;DefaultDir=" & App.Path & ";"
cn.Open strcn
' then how to open a recordset ?

Thanks