I am working on a system to store financial information. I will be extracting our accounts payable journal entries on a monthly basis into Excel. I want to import that data into an Access table. I have several calculations to perform to create new datafields that I need to store in my Access table. Is it possible to perform these calculations as I load the data? If so what the best method to do this? Here is an example. I will be downloading our monthly hardware depreciation and need to split it among departments based on % stored in another Access Table.

Thank you for any help you can provide me.

Teresa

Is it possible to perform these calculations as I load the data?

Probably not in a monolithic step unless the load involves opening the spreadsheet as a linked table. In which case you could do the computations in a query. Queries can contain formulas. Import Specifications cannot.

On the other hand, if you import to a temporary table, delete the rows that don't conform to your format (i.e. take out headers and such), then a query based on the temp table could do any computations you might need. Cleanup is easy then, because all you need to do is erase the temp table.