>store SQLSTRINGCONNECT(; > "DRIVER={Microsoft Excel Driver (*.xls)};" + ; > "FIL=Excel 97;" + ; > "DefaultDir=c:\;" + ; > "DBQ=c:\cim.xls"); > TO gnConnHandle > >CURSORSETPROP("FetchMemo",.t.,0) && set cursor properties in advance > >*It is important to have " and ' inside select/update statements as below >* field names are inherited from the first row in Excel columns > >?SQLexec(gnConnHandle, 'select * from "sheet1$"') >.... > >>