Maximum Number of Rows?

[Guest]

What is the maximum number of rows/columns an excel file can have?

Is there a limit in Access? If there is what is the limit? I have an enormous amount of data I need to move from a very antiquated system and a couple people believe we can use excel and access and I'm not entirely certain that is the best way to go to keep the integrity of it..

 

[JulieD]

Hi Kevin

Excel: max rows 65536 max columns 256
Access: Table size 2 gigabyte minus the space needed for the system objects

however, only 255 fields per table

Hope this helps
Cheers
JulieD

What is the maximum number of rows/columns an excel file can have?

Is there a limit in Access? If there is what is the limit? I have an

enormous amount of data I need to move from a very antiquated system and a
couple people believe we can use excel and access and I'm not entirely
certain that is the best way to go to keep the integrity of it..

 

[Andy B]

Hi

Excel has 256 columns and just over 65000 rows. If you have more lines than
this, use Access - it can go up to millions!

--
Andy.

What is the maximum number of rows/columns an excel file can have?

Is there a limit in Access? If there is what is the limit? I have an

enormous amount of data I need to move from a very antiquated system and a
couple people believe we can use excel and access and I'm not entirely
certain that is the best way to go to keep the integrity of it..