> > > but if someone else has done this.. whooho!
I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You
can find some other great utils there too.
This is the code I use to parse a CSV file... it creates an array not
a query though.
<!--- Convert CVS file to matrix(java.lang.String[][]) for easier
manipulation --->
<cflock timeout="10" throwontimeout="Yes" name="ImportTasks" type="EXCLUSIVE">
<cfscript>
f = createObject( "java", "java.io.FileInputStream" );
f.init("#REQUEST.DOCUMENT_DIRECTORY#\#File.ServerFile#");
parser = createObject( "java", "com.Ostermiller.util.ExcelCSVParser" );
parser.init( f );
csvArr = parser.getAllValues();
parser.close();
f.close();
</cfscript>
</cflock>
--
Marc
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
