>I need to import an Excel file into a DBF.
>
>I keep having a problem with the width and types of fields.
>
>Naturally I have tried to export (save as) the Excel to a DBF (dbf 4)
>
>I have tried to import into the DBF from the Excel (appe from XL5)
>
>I have exported Excel to a txt file (several types)
>
>ALL have problems with filed width.
>
>I can export (save as) the Excel sheet to a PRN file (formatted Text ) space delimited and that works GREAT, except it will wrap the text around after about 250 characters wide.
>
>If I do the PRN, I just build a matching DBF with all character fields. That works great, but it can NOT be a wide excel sheet.
>
>How can I set the page width to 1500 characters????
>
>How can I save an Excel file such that I can import it into a DBF with exact same spacing or at least ALL fields type Character?

This may not address all of your questions, but have you experimented with the import command? It seems to handle most situations quite well.

IMPORT FROM 'c:\ub\sf_custom_query.xls' TYPE xl5

Hope this helps...