Is the APPEND FROM XLS an option that would work for you? Are the spreadsheets standardized (number of columns and data types)?

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