More Rows

[Anne]

Hi, Like another poster I need more space in excel but my
problem is rows.
I'm exporting data from Access and have got to the
situation where I have no more blank rows. I'm at row
65536 now but only just over half way on the data export.
Is this the limit that excel allows?

 

[Norman Harker]

Hi Anne!

65536 Rows * 256 Column is the limit.

Can you not vary the criteria for exporting the data from Access
Import from Access with varied criteria.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[JE McGimpsey]

Yes it is.

 

[Anne]

Thanks for the information, it wasn't what I hoped to
hear but at least I'm not wasting any more time on it

Regards Anne