Hi,
i am in trouble!! I am getting an excel file every month (in the same format) with some data to analyse and transfer to a database (possibly Access) so i can keep a history of the data and the analysis.

I need to do an application that will allow users to select the new file, perform the calculations on the data and transfer to the access database and produce a report in excel format.

I have done this in Access (i am quite ok with Access db, but have not got any idea of Excel) with simple SQL but i need to get this done automatic.

Please, anybody can help? Would really be gratefull.

Thanks very much