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 > > > 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 package that would do automatic conversion >> from the dataset "schema" into a SQL Server CREATE TABLE statement >> (and INSERT INTO statements)? >> >> For example. >> >> > str(cars) >> 'data.frame': 50 obs. of 2 variables: >> $ speed: num 4 4 7 7 8 9 10 10 10 11 ... >> $ dist : num 2 10 4 22 16 10 18 26 34 17 ... >> > >> >> would become >> >> create table dbo.cars ( >> id int identity(1,1) not null, >> speed int not null, >> dist int not null, >> constraint PK_id primary key clustered (id ASC) >> on [PRIMARY] >> ) >> >> insert into dbo.cars >> values (N'4', N'2'), >> (N'4', N'10'), >> (N'7', N'4'), >> etc. >> >> -J >> >> ______________________________________________ >> 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. > > > > -- > Eric Lecoutre > Consultant - Business & Decision > Business Intelligence & Customer Intelligence > ______________________________________________ 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.