Message-ID: <d116dd150903140508o18f0749dj1ffa386dd9b63e74@mail.gmail.com>
Date: 2009-03-14T12:08:42Z
From: baked Toast
Subject: (RODBC) defining variable as text
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,