how to make a table with 10 million rows in one column?
in [General]
|
From: pemt on 26 Mar 2010 18:35 I just took a look at SAS and SPSS. Actually, the analysis that biologists need is not that complex as modeling algorithm, but very simple, such as simple comparison betwee two datasets, statistical significance analysis, ... The only thing is that datasets are large from 40,000 up to 200,000,000 records. Required queries and analysis are simple too. Thus, I thought Access would be a good interface for this. Wish to get more help from you in the future. Thanks for your help always. All the best, pemt "John W. Vinson" wrote: > On Fri, 26 Mar 2010 12:29:01 -0700, pemt <pemt(a)discussions.microsoft.com> > wrote: > > >Is there any way I will be able to process SQL > >database from Access interface, like running queries ...? > > Absolutely. SQL makes a great backend to Access, using ODBC to link the SQL > data. > > Having worked with some bioinformatics folks in the past... have you looked at > SAS or SPSS? Cheap, no; easy to configure, no; but lots of background in the > subject, certainly. > -- > > John W. Vinson [MVP] > . > |