General Question about Access capabilities

[auto.pilot]

I am new to Access and have been charged with investigating capabilities for a rather large project. We would like to extract peer group data from a wide range of files. We have quarterly data spanning 5 years.

Scope:
Historical Records: 20 quarters
Files for each quarter: 20
Line items in each file: 6500
Columns in each file: 115

To summarize, there will be approximately 400 data files to load, each with 6500 line items and 115 columns. That's around 300 million data points. We are using high-end new desktop PCs. The project is large (to me), so I'm wondering if Access can be used to manipulate data of this volume.

Would appreciate any thoughts.

thanks

Jim

 

[xenou]

It sounds like you could run into the 2Gb limit on Access DB's. That said, you can have one db that links to tables in other db's so that's a way around.

It doesn't sound hugely difficult what you are anticipating doing, just getting data into a database. Try it and see how it works. Other db's can be implemented if you find MSAccess to clunky: SQL Server (Express), Oracle (Express), MySQL, SQLite, FireBird, PostGre, and so on.