Thanks, but I'm not looking for a function to save dataframes into a
RDBMS. I'm looking for a function which creates CREATE TABLE and
INSERT statements from a dataframe.
-J
2010/10/5 Eric Lecoutre ericlecou...@gmail.com:
Hi,
You can have a look at RODBC and its function sqlSave.
HTH,
Eric
On Sat, Oct 9, 2010 at 9:02 AM, johannes rara johannesr...@gmail.com wrote:
Thanks, but I'm not looking for a function to save dataframes into a
RDBMS. I'm looking for a function which creates CREATE TABLE and
INSERT statements from a dataframe.
If the reason you want that is so you can
Package RSQLite has a dbBuildTableDefinition that creates the CREATE
TABLE statement for a given a data.frame. I think other db related
packages for MySQL and PostgreSQL also have such a function.
Michael
On 10 October 2010 00:39, Gabor Grothendieck ggrothendi...@gmail.com wrote:
On Sat, Oct
Have you considered the DBI and RODBC packages? I'm trying to
do something like this myself right now, and a post of my own (to
R-SIG-DB) produced recommendations for these two packages. Both have
vignettes.
Hope this helps.
Spencer
On 10/9/2010 6:52 AM, Michael
On Oct 9, 2010, at 9:02 AM, johannes rara wrote:
Thanks, but I'm not looking for a function to save dataframes into a
RDBMS. I'm looking for a function which creates CREATE TABLE and
INSERT statements from a dataframe.
(My first comment is speculation that Eric was intending that you look
Thanks Michael! dbBuildTableDefinition is something I was looking for
but it does not seem to support SQL Server table definitions (CREATE
TABLE statements may vary between different RDBMS).
Thanks anyway,
-J
2010/10/9 Michael Bedward michael.bedw...@gmail.com:
Package RSQLite has a
Hi,
You can have a look at RODBC and its function sqlSave.
HTH,
Eric
2010/10/3 johannes rara johannesr...@gmail.com
Hi,
R contains many good datasets which would be valuable in other
platforms as well. My intention is to use R datasets on SQL Server as
a sample tables. Is there a
Hi,
R contains many good datasets which would be valuable in other
platforms as well. My intention is to use R datasets on SQL Server as
a sample tables. Is there a package that would do automatic conversion
from the dataset schema into a SQL Server CREATE TABLE statement
(and INSERT INTO
8 matches
Mail list logo