What Excel version are you in?
Anyway, I doubt that you are using the relable option for converting xls file to VFP table. Probably VFP IMPORT ... xl8 command would be better here.
If you wish, send to me any of your Excel files that is not converted properly. I will see what is going on in details.
Regards
>I use Excel by automation, to convert XLS to DBF.
>
>I do:
>
>loExcel = CREATEOBJECT("Excel.Application")
>loExcel.Workbooks.Open("Somefile.xls")
>loExcel.Workbooks.SaveAS("Somefile.dbf",8)
>loExcel.Workbooks.Close(0)
>loExcel.Quit
>
>
>This does the job, without user interface, BUT not for all XLS-files. Some of them convert completely, some of them only convert the first 2 or 3 columns.
>
>When I do it manually, so I press SaveAs fom the menu, choose dbf 3, choose Yes (leave incompatible functions out), close the window, choose No, I always get ALL columns.
>
>So, somewhere in the statements above something is missing, telling Excel to convert all columns.
>
>Should I state somewhere the equivalent of "leave incompatible functions out"? How?
>
>TIA
>
>Lennert