Razzak/Karen, Thanks for the help.
Interestingly, the csv file loaded fine using Gateway. I now have used the R:Base text editor. No idea why I hadn't done that before. Nice. 16 rows were missing in the count when using LOAD. I unloaded the imported data as csv, added it as another tab to the original spreadsheet and compared the key field from the original with the unload data. Found 16 offending records. Each record had two "funny" characters (open square box) appended to any one field of the record. I am sure when I remove those it will work flawlessly. Thanks, Hans -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, December 15, 2008 11:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error code when LOADing CSV #118 At 12:42 PM 12/15/2008, Hans Manhave/Jackson-Lloyd wrote: >When using LOAD to import a CSV file I receive an error 32 times. > >The error is: '-ERROR- Incorrect number of values for this table ( 118)' > >Is there an quick way to figure out on which rows these errors happen? Hans, Here's how: 01. At the R> Prompt: SET LINES 0 LIST TABLE tablename Note the list of columns, exact sequence and data type 02. Open the CSV file in R:BASE or any Text Editor Compare the sequence and type of data 03. When using the LOAD command, DO NOT include the data for computed column(s), if defined. Hope that gives you some blues clues ... Very Best R:egards, Razzak.
