can't transfer data

M

Miguel

I have a database that is 80000 observations. I want to transfer this data
set to excel, but I can't do it since excel only allows 65000. Is there a way
to do it?

Thanks
Miguel
 
G

Gord Dibben

You could use a macro to split the data over two worksheets.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

Or just break the DB into a couple of manageable chunks and transfer in two
steps.

Either method does not keep the 80000 observations together however.

How about using Access to store the DB and Excel to pull over data based on
queries?

Buy Office 2007 in which Excel has one million+ rows per sheet.


Gord Dibben MS Excel MVP
 
Top