Reading and writing ODBC database

For questions and discussion related to reading in and working with data.

Reading and writing ODBC database

Postby HinderAlex » Wed Jun 29, 2011 4:35 am

I am planning to use an ODBC database with RATS. Reading an ODBC database works with the professional version, but I would also like to write RATS generated time-series (f.ex. indicators) back into the database. Is this possible? Is MS Access a good choice for a time-series based ODBC database?

Thanks
Alex
HinderAlex
 
Posts: 5
Joined: Thu Mar 08, 2007 10:23 am

Re: Reading and writing ODBC database

Postby TomDoan » Wed Jun 29, 2011 6:15 pm

HinderAlex wrote:I am planning to use an ODBC database with RATS. Reading an ODBC database works with the professional version, but I would also like to write RATS generated time-series (f.ex. indicators) back into the database. Is this possible? Is MS Access a good choice for a time-series based ODBC database?

Thanks
Alex


We haven't put COPY into ODBC into RATS, but I don't think there's a major problem with that as long as we write entire tables (the way that we do with spreadsheets). I have limited experience with MS Access; it seemed fine, but it did have a tendency to produce truly massive files (many, many times as large as the amount of actual data) if you weren't careful.
TomDoan
 
Posts: 3731
Joined: Wed Nov 01, 2006 5:36 pm


Return to Data: Reading, Writing, Transforming

Who is online

Users browsing this forum: No registered users and 1 guest

cron