Excel row's limit

[Guest]

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

 

[Guest]

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

 

[Guest]

sorry should have said i'm using excel 2003

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

 

[Mark Lincoln]

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

 

[Guest]

Excel 2003 has a limit of 65000 rows.

 

[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

 

[Guest]

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.

 

[jgibbings]

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