It may be from the consecutive delimiters (,,)
CF treats consecutive delimiters as a single character.
On Tue, Feb 17, 2009 at 6:51 PM, SAMARIS Software rai...@ozemail.com.auwrote:
The following is an extract from a txt / csv file I import into my sql
database
095,2 Bdrm S,Clean
Are you
1. importing the CSV to SQL Server via ColdFusion? or
2. generating the CSV with ColdFusion then using DTS tools to import
the CSV to SQL Server?
If 2, then perhaps the problem is with the DTS tools. Apparently when
importing excel or csv, it uses the first 8 rows of your file to
2009 10:37 AM
To: cfaussie
Subject: [cfaussie] Re: Problems Uploading CSV data into SQL table
Are you
1. importing the CSV to SQL Server via ColdFusion? or
2. generating the CSV with ColdFusion then using DTS tools to import
the CSV to SQL Server?
If 2, then perhaps the problem is with the DTS
AM
To: cfaussie
Subject: [cfaussie] Re: Problems Uploading CSV data into SQL table
Are you
1. importing the CSV to SQL Server via ColdFusion? or
2. generating the CSV with ColdFusion then using DTS tools to import
the CSV to SQL Server?
If 2, then perhaps the problem is with the DTS tools
On Wed, Feb 18, 2009 at 11:47, SAMARIS Software rai...@ozemail.com.au wrote:
the file to the server space and then I read the file and import data into
the sql server table via traditional cfquery insert.
Can you show us some code?
Chris
--
Chris Velevitch
Manager - Adobe Platform Users
Mobile: 0414 228 948
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Chris Velevitch
Sent: Wednesday, 18 February 2009 11:21 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Problems Uploading CSV data into SQL table
On Wed, Feb
It looks your odbc driver is the issue. What does cfdump on
daily_housekeeping_report show you?
Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au
Adobe Platform Users Group, Sydney
Feb '09 meeting: Hands On Cairngorm Basics
Date: Mon 23rd
Try looping over the .csv
!--- Read the file into a variable ---
cffile action=READ
file=#FORM.CSV_FILENAME#
variable=CSV_DATA_FILE
cfset CRLF = Chr(13)Chr(10)
cfloop index=CSV_DATA_LINE list=#CSV_DATA_FILE#