Page 1 of 1

"Maximum number of rows exceeded"

PostPosted: Thu Mar 13, 2008 4:33 am
by desert tarheel
If you go to http://phoenix.gov/phxpros.html, scroll over "Interactive Disclosure Center", and click on "COBRA data download," you will see "COBRA 8000 result records". This is a MS Access database containing the field usage and maintenence data for the most current model of alcohol breath testing machine in use by the Phoenix Police Dept.; criminal defense attorneys such as myself review this data in DUI cases to make sure the machine used to test the defendant was working properly and had been adequately maintained and quality assurance tested. But it is a big database (as you can imagine), and if you try to open it w/ OpenOffice, you get an error message that says "The maximum number of rows has been exceeded. Excess rows were not imported." This is not good. Anyone know what to do about this?

Re: "Maximum number of rows exceeded"

PostPosted: Thu Mar 13, 2008 8:49 am
by squenson
desert tarheel,

The big file (40 MB) contains 280,041 records, well beyond the limit of Calc which is 65,536. You should open the file using Base, the database tool provided with OOo. Open a new Base, then in the Wizard select the option "Connect to an existing database" and then in the combobox choose "dBase" and press the "Next >>" button. In the next window, type the path of the file, then again press "Finish", then finally select a place where to store the Base database. Then, you can click on the table RSTL8000 and browse through it.

Re: "Maximum number of rows exceeded"

PostPosted: Sat Mar 15, 2008 12:01 am
by DrewJensen
HI,

Well I went and downloaded the file. It is a dBase file not an MS Access file BTW. The web site lists MS Access as a tool for opening it.

However you can use Base to do so instead. The first problem is that when it downloads it is a file named RSLT8000.DBF and Base has a silly problem with the capital letters so rename the file with RSLT8000.dbf.

Now create a new Base file. File > New > Database
On the first page of the Base wizard select "Connect to existing database". In the drop down combobox select dBase and then follow the wizard, setting the location to the directory where you stored the file.

Using Base this way the file opened right up for me and displayed all 282,494 records. ( I did this under Linux but MS Windows should give you no problem either )