Need help creating a macro in excel

Hi Mr. Excel & All,

I need your help with a problem I'm having using excel at work. I am processing insurance policy payment information that comes to me in several excel spreadsheets. My job is to take only part of the data from the spreadsheet (the spreadsheets come with about 12 columns and I only need 9 columns of that data), this data then needs to be copied into an Access database table and imported into another database for processing.

My problem is that I have to create a macro in Excel that will do several things:
1. There are 5 columns with money figures in them, these dollar amounts need to be setup with 4 decimal points, example: 25,000.00 should look like 25,000.0000. This is the only way the theirs party database can work with the figures.

2. Allow me to copy only the columns that I need from the excel spreadsheet into the Access table so that I don't get error messages when trying to run my Access query.

Is there a way to create a macro that can do this, or am I stuck!

Please help, anyone!
Thanks,
Robin