Thanks Dennis, but my quotes are still the old Double style. Never
got all the program changes to make them single.
At 04:42 PM 2/11/2009, you wrote:
Dan,
Try changing your quote setting to a double quote before loading and
back to a single quote after.
Notice Excel uses the double quote in the CSV.
Dennis McGrath
----------
From: [email protected] [mailto:[email protected]] On Behalf Of Dan
Sent: Wednesday, February 11, 2009 3:34 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Incorrect Number of values (Load Command)
Hi folks,
I am having trouble with the LOAD command. I have a file from the
bank that is a .CSV file If I click on the file, xcel opens it
correctly as a 32 column file with data all correct. I created a
table with (at first only 32) 32 columns All TEXT values and did a
LOAD (tablename) from (filename) as CSV (yes I used correct table
names and file names.
I get the error "Incorrect number of values for this table ( 118)"
for each row in the file.
I added 15 more columns to see if that would help but no dice.
All columns are TEXT and large enough to hold data.
Any ideas?
A row of the data looks like this: (there are 523 rows)
1/27/2009,15:52:55,Batch List,H0049021,"JPMorgan Chase Bank,
N.A.",Vredevoogd Heating a,VREDEVOOGD,VRE,13452319312,Customer
Debits,DBT,Maintenance Agreements,1/15/2009,1,Submitted,FILE
ACCEPTED,MONICA SCOTT,SA10853,$13.00
,D,72403473,2153876053,C,59765,,10927,"$8,143.47 ",$0.00 ,$0.00 ,512,0,0
Oh I am using 7.5.25.30324 (and yes I will be upgrading to Turbo ASAP)
Thanks,
Dan
