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![]()




Reply With Quote