Home > Archive > Clipper > October 2007 > Getting the a dbf table's rows number
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Getting the a dbf table's rows number
|
|
|
|
Hello to all,
First of all, thank you for your answers to my message
about moving data from dbf files.
Since as some of you have said, if the dbf table contains
more then a certain number of rows, there could be a
problem in transferring data to en excel file, I would like
to know if there is a tool(in dos/clipper) that can retrieve
a certain dbf table's rows number
Getting an idea about the average tables row's number
first, will enable me to determine which export method to
take
Thank you
Amos
| |
| N:dlzc D:aol T:com \(dlzc\) 2007-10-14, 6:55 pm |
| Dear AMOS:
"AMOS" <am12348@walla.com> wrote in message
news:1192344748.178997.313690@i38g2000prf.googlegroups.com...
>
> Hello to all,
>
> First of all, thank you for your answers to my message
> about moving data from dbf files.
>
> Since as some of you have said, if the dbf table contains
> more then a certain number of rows, there could be a
> problem in transferring data to en excel file, I would like
> to know if there is a tool(in dos/clipper) that can retrieve
> a certain dbf table's rows number
Do you have clipper?
Do you have DBU.exe (which source is included with Clipper)?
> Getting an idea about the average tables row's number
> first, will enable me to determine which export method to
> take
Just try and open a file with Excel. If it doesn't work, then
you'll know the Access method (which is superior to Excel in
every way) is the way you must use.
David A. Smith
| |
|
|
| Joe Wright 2007-10-14, 6:55 pm |
| AMOS wrote:
> Hello to all,
>
> First of all, thank you for your answers to my message
> about moving data from dbf files.
>
> Since as some of you have said, if the dbf table contains
> more then a certain number of rows, there could be a
> problem in transferring data to en excel file, I would like
> to know if there is a tool(in dos/clipper) that can retrieve
> a certain dbf table's rows number
>
> Getting an idea about the average tables row's number
> first, will enable me to determine which export method to
> take
>
> Thank you
> Amos
>
Excel at 2.0 had a maximum of 16K rows. Modern Excel goes to 64K rows
only. Clipper .DBF tables can have millions of rows. For a particular
table, reccount() will tell you how many rows there are.
You have Clipper, right?
--
Joe Wright
"Everything should be made as simple as possible, but not simpler."
--- Albert Einstein ---
| |
|
|
"AMOS" <am12348@walla.com> je napisao u poruci interesnoj
grupi:1192344748.178997.313690@i38g2000prf.googlegroups.com...
>
> Hello to all,
>
> First of all, thank you for your answers to my message
> about moving data from dbf files.
>
> Getting an idea about the average tables row's number
> first, will enable me to determine which export method to
> take
>
> Thank you
> Amos
>
not knowing your skills, but dbf has record count written as long integer at
byte offsets 4, 5, 6, and 7 in dbf file [looking at raw file i/o having
offset 0 as first byte in the file]
so, it is very easy to make simple prog [in any tool] to read record count
from file
of course, having clipper comšiler, is the easiest way
| |
|
|
|
|
|