Hi Derek,
if you know what the field lengths and definitions are supposed to be then an quick approach is to create a table with the fields that you want.
Then import the excel sheet into this table with the command
append from myexelfile.xls xl8 sheet "MySheet"
the second xl8 defines the type of file to be imported-- this could xl5 or xls.
This approach has the advantage that you determine exactly the data structure of the created file. It has the disadvantage that the excel spreadsheet must have exactly the columns in exactly the order you have envisioned.
Jamie Beerbower
>Dear sir
>On the other hand, how to autofit the column in the Excel file ?
>because after convert the Excel file to DBF, I find the column width
>of the fields all in same length.
>
>Please advise.
>Thanks
>
>Derek Yim
James Beerbower
James Beerbower Enterprises
Frankfurt, Deutschland