>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