Have you tried using CFHTTP? It can also return a CSV/Text file as a query.
Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog Quoting Nick de Voil <[EMAIL PROTECTED]>: > Hello everyone, long time time since I was here. > > I'm trying to read a CSV file with CFQUERY using the ODBC > text driver as described at > http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. > > I get this error: > > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Text Driver] The Microsoft Jet > database engine could not find the object > 'C:\test\testfile.csv'. Make sure the object exists and that > you spell its name and the path name correctly. > > It doesn't matter where I put the file, I always get this > error. > > Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. > > Any ideas? > > Thanks > > Nick > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:269630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
