Excel & Recordset problem

[naruponk]

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

[Garratt]

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

[naruponk]

Thanks you Garratt

[naruponk]

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