Have you tried these custom tags? http://www.emerle.net/programming/display.cfm/t/cfx_excel2query http://www.emerle.net/programming/display.cfm/t/cfx_text2query
-----Original Message----- From: "Shib71" <[EMAIL PROTECTED]> Sent: Monday, March 6, 2006 12:03 am To: [email protected] Subject: Re: [CFCDev] Excel CSV Parsing Have you tried using cfhttp to import the csv? <cfhttp url="#relativeurl#" method="get" delimiter="," textqualifier="""" name="qFile"> This will give you a query "qFile" containing the contents of the file, using the first row as the name of the columns. As you can see, the tag can handle quotes as well. Blair On 3/6/06, Dustin Tinney <[EMAIL PROTECTED]> wrote: > > I've recently been trying to do a large import of a Excel or CSV file > generated from Excel. My efforts thus far have not been good and it's > looking like I will have to reinvent the wheel. > > I have yet to find a good article or paper on 1 Dynamic Datasources > using coldfusions built in support of the ODBC Socket with excel. I > was able to get my host to "add" a DNS of this type but haven't had > any luck getting a query to run using it. > > So after giving up on the ODBC Socket I figured I'd google my luck on > CSV and coldfusion. I have yet to find some one who does NOT assume > that the data won't contain a comma. Which to me just seems > ridiculous. Excel export to CSV puts "'s around rows with commas > > Example: > "foo, bar", foo, bar > > would be 3 items the first being foo comma bar. However I have yet to > find a good parser already written either in a UDF or even a CFC for > any of this. > > If any one has any help out there it's much appreciated > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of > the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting ( > www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
