Export FoxPro Table into Excel Sheet!

[Tuan Tran Quoc]

I have the big table in FoxPro that contains more than 60,000 records then
I export it to the Excel Format by using command :

Export to 'myfile.xls' Type XLS

But when i see the result in Excel . There is only about 16,000 records of
them.
Is there the limit that Excel could not handles with a big table or what ?

Any helps needs!

Thanks

[Andrew Baker]

Tuan,

The XLS format only supports 16,000 rows. In VFP use the XL5 format which
allows a much larger row limit, up to 64,000 (I think).

When I have to use the XLS format I usually warn the user when the record
count exceeds 16K rows.

Regards,

Andy (ôżô)

Tuan Tran Quoc wrote in message <#K7beXrz#GA.283@cppssbbsa03>...

[Holger Vorberg]

Hi,

thats right, as far as I know, Excel is limited to 16,000 rows !!

--
Holger Vorberg

MS Visual FoxPro MVP
dFPUG Regionalleiter Bielefeld
-------------------------------------- |\_/|
Prolib Software GmbH, www.prolib.de (.. )
Wir machen dem Fuchs Beine <g> - /

Tuan Tran Quoc schrieb in Nachricht <#K7beXrz#GA.283@cppssbbsa03>...

[Dan Thompson]

Tuan,

I just tried copying from a 1.4 million row table to an Excel 97 file.

Both commands XLS and XL5 copied 16,384 rows.

The XL5 format is for Excel 5 and can format date fields differently
than the XLS command. I would depend on the VFP format.

Anyway, what they are saying about 64,000+ rows is true and I have
done it before, I will have to try it when I get back to work and let you
know.

dan

Tuan Tran Quoc wrote in message <#K7beXrz#GA.283@cppssbbsa03>...

[Jerry Justic]

Not to be smug... but why would you want to copy this many records to an
Excel file? I see this all the time and I wonder why people try to make
Excel a database when it clearly wasn't designed to be one..

I am really curious what the application could be? Do you realize there are
a lot of database tools for analyzing large amounts of data in their native
database format?

And, once again, i am not trying to be a smart a$$.. just curious..

Jerry

[Dan Thompson]

Jerry,

I agree with you, however I am being ask to create Execl reports for our
auditors.

The reports should look just like the FoxPro reports, but be in Excel so
the Auditors (bean counters) can play with the data, because they don't
know any other tools.

dan

Jerry Justic wrote in message <7mq8f6$9pn$1...@bgtnsc02.worldnet.att.net>...

[Jerry Justic]

lol.. ok.. i figured as much... accountants learned 1-2-3 and excel years
ago and that's all they understand.. <g>
Jerry

Dan Thompson wrote in message ...

[IBMEKON]

"Jerry Justic" <JerryF...@worldnet.att.net> wrote:

>Not to be smug... but why would you want to copy this many records to an
>Excel file? I see this all the time and I wonder why people try to make
>Excel a database when it clearly wasn't designed to be one..
>
>I am really curious what the application could be? Do you realize there are
>a lot of database tools for analyzing large amounts of data in their native
>database format?
>
>And, once again, i am not trying to be a smart a$$.. just curious..
>
>Jerry
>
>Tuan Tran Quoc wrote in message <#K7beXrz#GA.283@cppssbbsa03>...
>>I have the big table in FoxPro that contains more than 60,000 records then
>>I export it to the Excel Format by using command :
>>
>>Export to 'myfile.xls' Type XLS
>>
>>But when i see the result in Excel . There is only about 16,000 records of
>>them.
>>Is there the limit that Excel could not handles with a big table or what ?
>>
>>Any helps needs!
>>
>>Thanks
>>
>>
>
>

I am in a similar situation with office 95 users.

I export to .dbf with fox2pro format option.
They use Access to select what they need to work on - and export to
xls spreadsheet.

Not great on a production basis, but ok for odd jobs.

[Anders Altberg]

Not any more. Excel 8 accepts 64000 rows
-Anders

Holger Vorberg <hol...@prolib.de> wrote in message
news:Ottb91sz#GA....@cppssbbsa02.microsoft.com...

| Hi,
|
| thats right, as far as I know, Excel is limited to 16,000 rows !!
|
| --
| Holger Vorberg
|
| MS Visual FoxPro MVP
| dFPUG Regionalleiter Bielefeld
| -------------------------------------- |\_/|
| Prolib Software GmbH, www.prolib.de (.. )
| Wir machen dem Fuchs Beine <g> - /
|
|
|

| Tuan Tran Quoc schrieb in Nachricht <#K7beXrz#GA.283@cppssbbsa03>...

[Anis]

Jerry,

For one, the autofilter feature in excel provides flexibility in viewing
data on the fly in any filtered format.
A large database in foxpro requires several reports to represent it
correctly. Whereas in excel, you can view the data any way you like in a
single sheet including graphing, formulating, and totalling.

the problem here is that in fpw26, when you export a database into excel,
numeric values do not transfer correctly, especially when opening the
resulting xls file in excel 97 or higher. The smart thing to do is convert
the database into a TAB delimited text file, and then import it into excel.

regards

Anis

Jerry Justic wrote in message <7mq8f6$9pn$1...@bgtnsc02.worldnet.att.net>...

>Not to be smug... but why would you want to copy this many records to an
>Excel file? I see this all the time and I wonder why people try to make
>Excel a database when it clearly wasn't designed to be one..
>
>I am really curious what the application could be? Do you realize there
are
>a lot of database tools for analyzing large amounts of data in their native
>database format?
>
>And, once again, i am not trying to be a smart a$$.. just curious..
>
>Jerry
>

>Tuan Tran Quoc wrote in message <#K7beXrz#GA.283@cppssbbsa03>...