Jerry,

basically:

loExcel = createobject("Excel.Application")
loExcel.Workbooks.OPEN(getfile('XLSX'))
 laData     = loExcel.ActiveSheet.RANGE(loExcel.ActiveSheet.Cells(1,1),loExcel.ActiveSheet.Cells(100,100)).VALUE

now you have an array.

Errorhandling and specials excluded. :)

Basic trick is to try the stuff via excel macro and transform into VFP. One can read cell by cell, but it's sloooow.

Lutz


>I import Excel file to dbf using:
>
>

>APPEND FROM myexcel.xls TYPE xls
>

>
>but it only works with old version of Excel (Office XP), doesn't work with new Excel file.
>
>do I need to install any tools?
>
>please advise
>
>thanks
>
>Jerry