Maximum Number of Rows?

K

Kevin

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

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

Kevin said:
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
Click to expand...
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..
 
A

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.


Kevin said:
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
Click to expand...
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..
 
Top