Excel & Recordset problem

Hi all,

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

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 :wave:

http://www.exceltip.com/st/Use_a_clo...Excel/432.html

Thanks you Garratt:)

Hey guys,

but how can i transfer data from excel file to table in access?

like this in DAO

do while not xrs.eof
rs.addnew
rs.fields!fname=xrs.fields!firstname
rs.update
xrs.movenext
loop

thanks