>hi all,
>How do I read an Excel file row by row then import it to dbf ?
>
>*eg. MyExcel = GetObject(pathname)
>
>Thank you.

Chua,
Reading excel file row by row would be an overkill. Instead save as a dbf.

lcOutFile = 'mytable.dbf'
#define xlDBF3  8
#define xlDBF4  11
oExcel=createobject('Excel.Application')
with oExcel
 .Workbooks.Open(lcExistingXLSFullPath)
 .ActiveWorkBook.ActiveSheet.SaveAs(sys(5)+curdir()+lcOutFile,xlDBF3)
 .Quit
endwith

Cetin