: [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
://www.emerle.net/programming/display.cfm/t/cfx_text2query
-Original Message-
From: Shib71 [EMAIL PROTECTED]
Sent: Monday, March 6, 2006 12:03 am
To: CFCDev@cfczone.org
Subject: Re: [CFCDev] Excel CSV Parsing
Have you tried using cfhttp to import the csv?
cfhttp url=#relativeurl# method=get
If you're looking to do a one time or occasional import, you could look
at using Navicat, which is an excellent MySQL GUI.
www.navicat.com
Dustin Tinney 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
[EMAIL PROTECTED]
Brent Nicholas - Michigan DJ Service
http://www.MichiganDJService.com
248.767.5516
[EMAIL PROTECTED]
Do
From: Nando [EMAIL PROTECTED]
Reply-To: CFCDev@cfczone.org
To: CFCDev@cfczone.org
Subject: Re: [CFCDev] Excel CSV Parsing
Date: Mon, 06 Mar 2006 21:02:45 +0100
MIME
- EclecticDetroit, LLC. http://www.EclecticDetroit.com 248.767.5516
[EMAIL PROTECTED] Brent Nicholas - Michigan DJ Service http://www.MichiganDJService.com
248.767.5516 [EMAIL PROTECTED] Do From: Nando [EMAIL PROTECTED]
Reply-To: CFCDev@cfczone.org To: CFCDev@cfczone.org Subject: Re: [CFCDev] Excel
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
Have you tried using cfhttp to import the csv?cfhttp url="" 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,
However I have yet to find a good parser already
written either in a UDF or even a CFC for
any of this.
You could try this out, just read the page first:
http://www.olimpo.ch/tmt/cfc/tmt_csv
There are CFX alternatives that tend to be much more robust:
http://www.emerle.net/programming/
Or