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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham