Excel row's limit

S

Simon (Novice)

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
 
D

Dave F

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
 
S

Simon (Novice)

sorry should have said i'm using excel 2003

Dave F said:
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
Click to expand...
 
P

Pete_UK

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

Hope this helps.

Pete
 
S

Simon (Novice)

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.
 
G

gimmemo

Simon said:
i am trying to export some data into an excel spreadsheet from a voxpr

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

many thanks
Click to expand...

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