Mass Import from Excel to aggregate data

[swift1]

Hi,

Complete and utter Access beginner here, I'll lay out my problem and you can judge the best way to approach it

I have 300++ Excel files that contain data in the format of column1 = textual identifier, column2 = numerical value. Each file can have up to 1300 rows. The text identifier will be 95% the same in all files with slight variations.

I want to create a database to store the numerical value of each identifier from every excel spreadsheet and average the value.

This should be ~1300 instances, each with 300++ value assigned to it. Then run a report to pull the average value of every instance/identifier.

My (many) questions as follows..

-Is Access a good way to go about this?
-Is there an efficient way to bulk import from excel ( I just saw a script to do this below )?


-General advice how to set up tables/queries/relationships?

Take it slow, I'm not too intuitive with access yet!

Thanks for your time.

[ranman256]

Yes, i use access to do this all the time.
you can import them all 1 at a time, manually or, with a macro , in the macro is transferspreadsheet.

or
there is code that can import EVERY workbook in a folder into a single table.

[ssanfu]

Ken Snell has a site about Importing and Exporting Excel files that is (can be) helpful.... but is does involve VBA.

http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm