Prev: Additional Information
Next: Pie chart in columnar report
From: Jeff Boyce on 23 Mar 2010 14:36
Thanks, John. Clearly I wasn't getting through <G!>

Jeff B.

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:vdohq51adqltju2tpn1ljf6ckmlcg7lgf3(a)4ax.com...
> On Tue, 23 Mar 2010 06:53:01 -0700, pemt <pemt(a)discussions.microsoft.com>
> wrote:
>
>>actually I have more than 10 M records to fill with and each one is
>>unique.
>
> THEN STOP!!!!!
>
> It is not necessary to create ten million empty records and then fill them
> in.
>
> Simply use an Autonumber ID. Add the records as the data becomes
> available -
> importing, appending, entering with a form. Create the record *when there
> is a
> record to create* - not before.
> --
>
> John W. Vinson [MVP]


From: John W. Vinson on 23 Mar 2010 14:46
On Tue, 23 Mar 2010 10:03:01 -0700, pemt <pemt(a)discussions.microsoft.com>
wrote:

>Thanks a lot!
>
>"John W. Vinson" wrote:
>
>> On Tue, 23 Mar 2010 06:53:01 -0700, pemt <pemt(a)discussions.microsoft.com>
>> wrote:
>>
>> >actually I have more than 10 M records to fill with and each one is unique.
>>
>> THEN STOP!!!!!
>>
>> It is not necessary to create ten million empty records and then fill them in.
>>
>> Simply use an Autonumber ID. Add the records as the data becomes available -
>> importing, appending, entering with a form. Create the record *when there is a
>> record to create* - not before.

I'm just really curious... what kind of data do you have, and where is it
coming from? If it's ok to post a general description several of us would be
interested.
--

John W. Vinson [MVP]
From: pemt on 23 Mar 2010 15:05
kc-mass,

I tried to run this code, but the error came out "cannot find input table or
query 'tblBig1'."


"kc-mass" wrote:

> Try this: Set it off and wait two or three minutes depending on your
> machine.
>
> Sub MakeBig()
> Dim strSQL1 As String
> Dim strSQL2 As String
> Dim lngCount As Long
> On Error GoTo E_Handle
> strSQL1 = "INSERT INTO tblBig2 ( [key] ) SELECT tblBig1.key FROM tblBig1;"
> strSQL2 = "INSERT INTO tblBig1 ( [key] ) SELECT tblBig2.key FROM tblBig2;"
> DoCmd.SetWarnings False
> Do While lngCount < 1000
> DoCmd.RunSQL strSQL1
> DoCmd.RunSQL strSQL2
> lngCount = lngCount + 1
> Loop
> DoCmd.SetWarnings True
> sExit:
> On Error Resume Next
> DoCmd.SetWarnings True
> Exit Sub
> E_Handle:
>
> MsgBox Err.Description, vbOKOnly, Err.Number
> Resume sExit
> End Sub
>
>
>
>
> "pemt" <pemt(a)discussions.microsoft.com> wrote in message
> news:C8BB251F-1845-4148-8E4A-DFC344AC971A(a)microsoft.com...
> > how to make a table with 10 million rows in one column?
> >
> > Num
> > 1
> > 2
> > 3
> > .
> > .
> > .
> > 10,000,000
> >
> > thanks,
> >
> > pemt
>
>
> .
>
From: pemt on 26 Mar 2010 15:29
Hi John and others,

sorry for the late response.
The data are from bioinformatic data. Actaully I am a biologist. Now data
analysis took really long long time for those bioinformaticists as compared
with our wet bench work. Thus, I try to find a simple way/interface for
biologists to analyze their own data from large dataset. Access can be easily
handled by many computational dummies like me, though Access might not be
good for very large datasets. But with you guys' great help, it worths to
try. And it works for me to analyze some relatively small datasets now. SQL
might be a better choice. Is there any way I will be able to process SQL
database from Access interface, like running queries ...?

Thanks a lot,

pemt


"John W. Vinson" wrote:

> On Tue, 23 Mar 2010 10:03:01 -0700, pemt <pemt(a)discussions.microsoft.com>
> wrote:
>
> >Thanks a lot!
> >
> >"John W. Vinson" wrote:
> >
> >> On Tue, 23 Mar 2010 06:53:01 -0700, pemt <pemt(a)discussions.microsoft.com>
> >> wrote:
> >>
> >> >actually I have more than 10 M records to fill with and each one is unique.
> >>
> >> THEN STOP!!!!!
> >>
> >> It is not necessary to create ten million empty records and then fill them in.
> >>
> >> Simply use an Autonumber ID. Add the records as the data becomes available -
> >> importing, appending, entering with a form. Create the record *when there is a
> >> record to create* - not before.
>
> I'm just really curious... what kind of data do you have, and where is it
> coming from? If it's ok to post a general description several of us would be
> interested.
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 26 Mar 2010 16:06
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]
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: Additional Information
Next: Pie chart in columnar report