I would like somebody to:
1. Download the latest publicly available bank holding company data files (CSV) for each quarter from 2002 to 2012. There should be 48 files. Data files can be found here: [url removed, login to view] (This is a public data site with no restrictions on access).
2. Import each file into a single Microsoft Access 2010 database. The data from the 48 files should be in one or more standard tables. Note:
- The CSV files have close to 2000 fields in them. Since this is larger than the maximum allowed fields in Access (255 field max), you will need to find a way to split the CSV into multiple tables and ensure the right Primary Key data is stored with the right records in each table.
- Primary keys are across the following multiple fields: RSSD9001, RSSD9017, RSSD9999, RSSD9007, RSSD9008
Payment will be made when the project is complete.