Dear all, I use the RODBC package to import data from a Microsoft Access database. When importing the different variables I use a marker, a unique code which consists of a series of numbers starting with several (not a fixed number) of zero's. Now the problem is that when I want to import this data to R with the RODBC package (the used code is displayed on the bottom of this message) it converts this marker to a number and cuts of the starting zero's. Is there a possibility to avoid this?
The code used for importing the data: > library(RODBC) > data <- odbcConnectAccess("testDB") > sqlTables(data) > GDATA = sqlFetch(data,"testdata") > odbcClose(data) Kind regards, ______________________________________________ R-help@r-project.org 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.