RStudio Edition : Desktop RStudio Version : 1.2.1511 OS Version : Windows 7 R Version : 3.6.0
I am connecting my organisation's database using Sybase IQ as well as RStudio via ODBC connection.
I can export SQL results to a
csv file in Interactive SQL app with the following codes
select top 10* into #test from DATA; select * from #test; output to "E:\\test.csv";
output to nor
into outfile (in some other suggestions) works via RStudio's SQL engine.
Is there anyway I can achieve this?