Hi,

I also had similar problem with excel file.
One of my excel file columns when save as dbase IV,
all the date columns will be truncated to only 19.

Other excel file are okay.

On the other hand, when I import the first file (save as dbase IV,
causing truncated date), all the date field will give numeric value,
not as date

For the excel file (save as dbase IV, working fine), all the date field
are fine.

Any advise or comment for me.
Thank you


>>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...