I am looking at the code from sweetpotatosoftware. By description it should be very useful. If you have not used the product, feel free to ignore my message (maybe then I will start a new thread). So here is where I need help:

When I start the sample program I get a window "Select Data Source" where I have to enter DSN Name. Then on the top of this field there is a choice to Look in (where it defaults to My Documents). Obviously there is nothing in My Documents that has anything to do with DSN Name. My question is, which folder on my computer should I be looking into? And/or what DSN name should I enter?


>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