[RBG7-L] - Re: Load file into a col

[Marc]

Thanks David   That was what I was looking for, I think the quotes were the problem.   Marc   ----- Original Message ----- From: David M. Blocker To: RBG7-L Mailing List Sent: Wednesday, July 07, 2004 3:37 PM Subject: [RBG7-L] - Re: Load file into a col Marc   If you are loading into a single column, then it's:   Load Tablename FROM filename USING columnname   or, if that doesn't work,   Load Tablename FROM filename USING columnname AS ASCII   Just be aware that R:Base will normally treat BOTH a comma AND a space as a "delimiter", separating one column from another.   So if the file reads:   Joe is here   MaryAnn,John,Bill   Each of these samples will be seen by R:Base as THREE columns of data.   Placing quotes around values will help:   'Joe is here'   'MaryAnn,John,Bill'   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Marc To: RBG7-L Mailing List Sent: Wednesday, July 07, 2004 1:12 PM Subject: [RBG7-L] - Load file into a col HI all   I did this several years ago but can't seem to remember how I did this.   I have about 200 small files and I want to load them into a table in my data base.   Thanks Marc