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 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]
--
<http://aria-media.com/>
Aria Media Sagl
CP 234
6934 Bioggio
Switzerland
www.aria-media.com <http://aria-media.com/>
----------------------------------------------------------
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]
