Hi All...

I have an Excel worksheet which can have many columns. The header column has data which correspond to the field names in a DBF table. How can I identify which column #'s are ITEM & PRICE and whether thay contain character or numeric data ?

Listed below is my attempted code. Any help is greately appreciated.

Thank You in advance..

Raz

LOCAL oExcel, lcItem, lnCost
lcFile = "HITACHI.XLS"

oExcel = CREATEOBJECT("Excel.Application",)
oExcel.Workbooks.Open(lcFile)
oExcel.Workbooks(1).Sheets(1).Select()
oExcel.Cells.Select
mnLastRow = oExcel.activesheet.UsedRange.ROWS.COUNT
rr = oExcel.activesheet.UsedRange.ROWS.COUNT
mcLastRow = ALLTRIM(STR(mnLastRow))

lcItem = oExcel.Cells(rr,??).value		&& oExcel.Cells(rr,08).value
lnCost = oExcel.Cells(rr,??).value		&& oExcel.Cells(rr,12).value