>>>Hi,
>>>I usually convert an excel spreadsheet to a DBF file by first saving it into a CSV format and then importing into a DBF.
>>>
>>>But this spreadsheet (attached) does not have a clear structure of columns. The attached spreadsheet shows the pattern; the actual one has many more “records”
>>>
>>>How would you devise a plan to convert such a spreadsheet to a DBF?
>>
>>I'll use Automation to read this file.
>
>Could you, please, clarify what you mean by Automation? Sorry that I have not looked at and did any of the automation in a long time.

Something like:

oExcel = CREATEOBJECT("Excel.Application")
oExcel.WorkBooks.Open(full_path_to_file_here)
** read sheet information.
oExcel.Close()
oExcel.Quit()
oExcel = null