Aloha,
Forgive my ignorance - no Java background but longtime CF developer.
I have tried this off an on in the past with no luck. I built a test
page, with the following. Any assistance would be appreciated...
<cfscript>
filename = 'd:\test.xls';
CreateObject('java','java.lang.Class').forName
('sun.jdbc.odbc.JdbcOdbcDriver');
c = CreateObject('java','java.sql.DriverManager').getConnection
('jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=d:
\test.xls' );
sql = "SELECT * FROM [address$]";
stmnt = c.createStatement();
rs = stmnt.executeQuery(sql);
myQuery = CreateObject('java',
'com.naryx.tagfusion.cfm.engine.cfQueryResultData').init(rs, "EXCEL
FILE", -1);
</cfscript>
<cfdump>
This results in: Microsoft][ODBC Excel Driver] The Microsoft Jet
database engine could not find the object 'address$'. Make sure the
object exists and that you spell its name and the path name correctly.
Any help is appreciated,
Thanks,
Rob
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
