Thank you, Tore. I will read these resources as I have to convert a large excel into a SQL database and I only know of how to do it via VFP.

>http://www.foxpert.com/docs/excel.en.htm
>http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx
>
>>Thank you, Borislav. So there is no way to import from MS Office 2010, right?
>>
>>Also, on the same subject, if you don't my asking. I was importing from a spreadsheet saved as MS Office 2003 but the VFP would bomb every time. Could it be because some columns of the spreadsheet have NULLs?
>>
>>>>PMFJI, what is type XL8? Would it be MS Office 2003?
>>>
>>>Yes.
>>>
>>>
>>>>
>>>>>XLS Excel 4
>>>>>XL5 Excel 5 ( MS Office 97)
>>>>>
>>>>>MartinaJ
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>What different between the type XLS and XL5 in the EXPORT TO
>>>>>>command ?
>>>>>>
>>>>>>Because I found that if I export a date field using XLS to a worksheet,
>>>>>>the date column can't be sorted by using the sort button {A->Z} in MS Excel.
>>>>>>but, can sorted if I using the XL5 type to export.
>>>>>>
>>>>>>Why ? please advise.
>>>>>>Thanks
>>>>>>Derek