>hi all,
>
>i have this fields a,b,c,d with data at myexcel sheet(aar.xls) at directory e:\,
>and i have this fields a,b,c,d,E at mytable (book1),at E field i insert numbers as 1,2,3 ..,
>i need to replace all data from excel sheet to mytable ,but field E stay as it is.
>
>and when i make the replace operation i need to begin from record 6 excel sheet,
>i mean i want to skip records 1,2,3,4,5 and 6 ,begin replace from record 7 to mytable.
>
>
>thanks.
>m.qasem

Mohammed,
What you say needs some management. I suggest you to get the data into a table first. Then you might manage it easier. ie:

lcXLS = "e:\aar.xls"
lcTable = sys(5)+curdir()+"XLData.dbf"
oExcel = createobject("Excel.Application")
with oExcel
 .DisplayAlerts = .F.
 .WorkBooks.Open(m.lcXLS)
 .ActiveWorkBook.SaveAs(m.lcTable,8)
 .ActiveWorkBook.Saved = .T.
 .Quit
EndWith
USE (m.lcTable)
browse

Cetin