View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default excel vs. access

In practical terms:

1. Unless you have only modest amounts, storing data in a 'proper'
database would allow faster access.
2. Although a single Jet (MS Access) table is limited to 255 columns,
you may use more than one table and join them very efficiently in
queries.
3. You would probably end up with a better structure to both your data
and your application.

Jamie.

--