How many columns are returned in
lnCols = .UsedRange.columns.count
>
>I have an Excel file containing Arabic. I've simplified my convert to DBF routine to this:
<snip>
>
>Still when I try it, it creates only 8 fields our of 40. If I do the same process manually (e.g. open Excel, select used cells, save as DBF4 format), all 40 fields are created. In both cases Arabic become ?????????, but I'm not worried about this at the moment.
>
>Do you know what's wrong with my code and why it doesn't work?
>
--sb--