At the risk of being one of those people who doesn't answer the question and tells you something you already know... Are you aware that you can save an XLS to a DBF?

As to your question, I don't know. Sorry.

Michelle

UPDATE: Just thought of something... How about not using a for loop? Use a DO WHILE there is something on the line?

>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