John Colby
jwcolby at ColbyConsulting.com
Thu Jan 19 11:14:42 CST 2006
Does anyone know the syntax in an SQL statement for seeing a named range in an excel spreadsheet? I have a spreadsheet DocumentRequestTemplate.xls, which has a sheet xlsReqForDocuments which has a named range Sec_DocWithHdr, Sec_DocNoHdr etc. I assume that the syntax would look something like SELECT * from SEC_DocWithHdr IN DocumentRequestTemplate.xls Doing this gets me "unrecognized database format" however. Anyone know what the real answer is? John W. Colby www.ColbyConsulting.com