Ahh... I feel much better now. Worked great. Thanks.
At 04:37 PM 2/11/2009, you wrote:
Dan,
You could look into the GATEWAY IMPORT command.
Jan
-----Original Message-----
From: Dan <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 11 Feb 2009 16:34:21 -0500
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
