>Hello All:
> Is it a way to figure out how much line in a xls file? I am trying to create a loop for importing a xls file to dbf. Thanks
>sherry

Sherry,

Would your Excel file be always in the same format? If yes, you can create a table with the necessary structure and do:

create table (tablenam) (....)
append from XLSSource.xls xls

Note, this would not work, if any of the fields is more than 255 chars and require Memo field.