lcFileIn = "C:\Test\Per-Key Generic Template Sheet.xls" lcConnstr = "Driver={Microsoft Excel Driver (*.xls)};DBQ=" + lcFileIn + ";" lnSQLHand = SQLSTRINGCONNECT( lcConnstr ) ? lnSQLHand ? SQLEXEC( lnSQLHand, 'Select * FROM "DataEntry$"', 'trt' )The error is Connectivity error: [Microsoft][ODBC Excel Driver] The connection for viewing your linked Microsoft Excel worksheet was lost.
lcFileIn = "C:\Test\Per-KeyGenericTemplateSheet.xls" lcConnstr = "Driver={Microsoft Excel Driver (*.xls)};DBQ=" + lcFileIn + ";" lnSQLHand = SQLSTRINGCONNECT( lcConnstr ) ? lnSQLHand ? SQLEXEC( lnSQLHand, 'Select * FROM "DataEntry$"', 'trt' )And of course every example I can find on the web never has spaces in the path... putting it in quotes and braces has not worked either. So how does one specify spaces in their DBQ in VFP6? FWIW the code doesn't error in VFP8.