we have tried this and are using it, somewhat different in how things go, but you can set up a datasource to a folder, and then your queries are something like
select * from somefile.csv and if there's a header line in the csv, you will get a nice normal query to work with after that point. works out pretty well in small files that are being uploaded, and not knowing the name of the file you're going to be parsing through beforehand. we haven't really tried bringing in a very large file this way, but just to make the query, you can see that it would take a large amount of ram to hold the query object. -----Original Message----- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 1:50 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] help reading a text file... I haven't tried this, but there is a Microsoft ODBC text driver that supports TXT (Text files) and CSV (comma delimited files). You may be able to setup an ODBC connection to this file. Randy Ellis Senior Programmer Analyst City of Overland Park -----Original Message----- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 12:56 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] help reading a text file... what's the best way to read a very large tab delimeted text file? does cf.. read the whole file into one variable... how does this get effected if you're reading a large file? Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] <<Johnson, Michael.vcf>> ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
