OK, I'm glad to see you found a solution! ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Sent: Wednesday, February 11, 2009 4:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Incorrect Number of values (Load Command)
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
