>HI,
>I finally managed how to connect a remote view to an Excel spreadsheet. The only thing that is annoying me is the fact that the user need to select a workbook each time the view is opened. Is there a way to programmatically eliminate this step ? I wolud like to supply the user a specific workbook to be opened.
>
>Thank you for your help,
>Christian Cote

Maybe you can use SPT?

lcConnStr = "" + ;
	"DRIVER=Microsoft Excel Driver (*.xls); " + ;
	"UID=admin; " + ;
	"UserCommitSync=Yes; " + ;
	"Threads=3; " + ;
	"SafeTransactions=0; " + ;
	"ReadOnly=0; " + ;
	"PageTimeout=5; " + ;
	"MaxScanRows=8; " + ;
	"MaxBufferSize=2048; " + ;
	"FIL=excel 8.0; " + ;
	"DriverId=790; " 
	
lcDir = "H:\temp" 
lcExcelFile = "H:\temp\test01a.xls"

lnCon = SQLSTRINGCONNECT(lcConnStr + ;
			"DefaultDir=" + lcDir + "; " + ;
			"DBQ=" + lcExcelFile + ";")

* GetName of the table
lnRet = SQLTABLES(lnCon)
lcTable = Alltrim(table_name)

SQLEXEC(lnCon, [SELECT * FROM "] + lcTable + [" ExcelTable], "Mycursor")