I am trying to convert some code that I currently use with Adobe CF to
work on OpenBD to import excel files. Basically I was using the java
jdbc connector for excel. Is there an equivalent for the java object
"coldfusion.sql.QueryTable"?
Here is how I am using it:
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=' &
arguments.filename );
stmnt = c.createStatement();
rs = stmnt.executeQuery(sql);
myQuery = CreateObject('java','coldfusion.sql.QueryTable').init(rs);
The file that would be processed would be uploaded by a user and may
have an assortment of names, so I don't really want to create an ODBC
connection from within windows if at all possible. Also would like to
NOT force the user to create a CSV, but that may be the easiest way to
skin this cat.
--~--~---------~--~----~------------~-------~--~----~
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 !!
-~----------~----~----~----~------~----~------~--~---
