View Single Post
  #3   Report Post  
Allan Bach
 
Posts: n/a
Default

Is it possible to have more than 65000 entries in Access?

kr.

Allan


"Arvi Laanemets" skrev:

Hi


"Allan Bach" (DONOTSPAM) wrote in message
...
Hi

In Excel the maximum number of rows i can get is 65536. Is it possible to
extend this so i can get about 67000 rows?


Not on same sheet!

Your options:
Delete some abundant rows, when you have them;
Distribute your data to several worksheets;
Redesign your worksheet, so that the number of needed rows decreases (in
case it's possible to collect the info from several rows to one single row);
Switch to Access or to any other database application;
Swithc to QuattroPro.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



Kind regards

Allan Bach