I have some Stuff to import records from XLSX file using SQL Connect. But right now it is not available, perhaps kept in my old Desktop.
I will mail it to you in a day or two.
Harsh
>Check
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx>
>>I import Excel file to dbf using:
>>
>>
>>APPEND FROM myexcel.xls TYPE xls
>>
>>
>>but it only works with old version of Excel (Office XP), doesn't work with new Excel file.
>>
>>do I need to install any tools?
>>
>>please advise
>>
>>thanks
>>
>>Jerry
Harsh