Hi Richard, It would help if you provided a bit more on how you are going about the import (along with your version of R and RSQLite).
R Gott <[EMAIL PROTECTED]> writes: > I haev some .csv data files with missing values - eg below > > 1,'F','C04','X100',20.93,'C','B',7,8,7.5,2421,2230,2230,2,1,85,43,85,46,48,60 > > If I have a missing value - so file looks like ,85,46,,48, etc > then RSQLite reads it as zero. ,85,46,0,48, etc > I need it read it as NA. > > Tried various combinations with no success, adn found nothing on help > site. Must be somehting very simple but . . . . > > Help much appreciated. The most flexible approach would be to use read.table to read in your csv file. Then use dbWriteTable to put the resulting data.frame object into the DB. + seth ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
