>More explanation pls. Blindly clue commands :
>with oExcel.ActiveSheet.Cells(nRow.nCol).CurrentRegion
>lnColumns = .Columns.count
>lnRows = .Rows.Count
>
>oRange.Offset(nRow, nCol)
>Cetin
Cetin,
Thanks already the Currentregion is pointing into the right direction but isn't bulletproof.
Let's say you have an excel sheet with the first five rows who are blank.
Than the following rows contain the data to import.
Now using the IMPORT FROM
XLS in Foxpro imports the excel sheet into a DBF with the same name. But what you see is that the first five rows of the excel sheet aren't in the imported DBF. The first record of the imported excel sheet is the data from the 6th row in the excel sheet.
Hope this clears out more what I am looking for. Hope you have any more ideas.
TIA.