Excel row's limit
 

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

Excel 2003 has a maximum of 65,536 rows. Are you getting an error?

Simon (Novice) wrote:
sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

Excel 2003 has a limit of 65000 rows.
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

Check you settings in FoxPro - you may be creating the file as an Excel
5 (i.e. 95) file.

Hope this helps.

Pete

Simon (Novice) wrote:
sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

no error, when i run the export it fills the first 16,384 row's and according
to the program i'm exporting from it's done the job right but excel won't
fill more row's. if i export to .dbf all the data is there so the program is
sending out the correct data but excel doesn't like it. have run all updates.

"Mark Lincoln" wrote:

Excel 2003 has a maximum of 65,536 rows. Are you getting an error?

Simon (Novice) wrote:
sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

If it exports to dbf ok then export to dbf then import the dbf file
into excel.


Simon (Novice) wrote:
no error, when i run the export it fills the first 16,384 row's and according
to the program i'm exporting from it's done the job right but excel won't
fill more row's. if i export to .dbf all the data is there so the program is
sending out the correct data but excel doesn't like it. have run all updates.

"Mark Lincoln" wrote:

Excel 2003 has a maximum of 65,536 rows. Are you getting an error?

Simon (Novice) wrote:
sorry should have said i'm using excel 2003

"Dave F" wrote:

You're using a really, really outdated version of XL.

Your solution is to use XL 97 or later which gives you 65,000 rows of data
(1 million with XL 2007).

Dave
--
Brevity is the soul of wit.


"Simon (Novice)" wrote:

i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?

many thanks

Excel row's limit
 

Simon (Novice) Wrote:
i am trying to export some data into an excel spreadsheet from a voxpro

program, there should be 20,390 rows of data to be exported but excel
only
allow's 16,384. is there a fix for this or a way around it?

many thanks

You may be exporting too much data. Try limiting the fields to just a
few key ones to see if you get all the rows then go back and start
adding more fields.
Jim




--
gimmemo