Thank you, that worked very nicely. So much better too, then looking at it in a spreadsheet.
Hans -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Wendike Sent: Monday, December 08, 2008 8:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Importing a CSV file Han, instead of using Gateway, use the LOAD command. With 900,000 rows, it will be much faster than Gateway. Besides if the table is already defined and the CSV file has the corresponding information, ie same columns as the table, then it should be a snap. Gary ________________________________ From: Hans Manhave/Jackson-Lloyd <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, December 8, 2008 4:58:47 PM Subject: [RBASE-L] - Importing a CSV file I'm working with Excel 2007 and saved the .XLSX file as a comma delimited CSV so I can import it in R:Base 8. I created a database with a dummy table and selected GATEWAY. I designated I wanted a new table, named it, selected the import format, changed the field1/field2/field3 etc. to the right field names and data types etc. Then I clicked on the 'ok' button and nothing happens. I can keep clicking. It's a 900,000+ file, but there is no indication that anything is happening. I missed something obvious, I guess? --- Hans Manhave Operations Director Jackson-Lloyd Ins P.O.Box 187 Longview, TX 75606 903-758-6206
