I'd connect to it as a data source, I think. It's just less for the client to do. Of course, the file will have to be named the same thing each time, else you'd have to create a new DSN each time for each differently named file.
Check out their type 4 JDBC Excel driver <http://hxtt.com/excel.html> available on www.HXTT.com <http://hxtt.com>. I'm currently using their Type 4 DBF driver for visual FoxPro, and it works like a champ. The developers, are very ready to help any of their users via email. I've never used their text drivers, but I imagine they're not too hard to get the hang of. Hope this helps. Cheers, Chris Andy Matthews wrote: > I have a client who wants me to build a quick admin tool for him. It would > allow him to upload 2 files from different dates and list the differences. > It's bascially two Excel files with 4 columns each and about 9000 lines > apiece. > > So my question is, would it be better to connect to the Excel file as a > datasource or have him convert to a CSV text file and upload that way? He'll > be using this tool each day to compare the current day's file to the > previous day's file. > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
