This is my first time working with importing data.  I have payment files in
excell that I want to import(but only two of the fields out of several) into
an existing Access payment table.  

Payment table (Access) consists of following fields:
Reference Number    Payment Date   Payment Amount     Payment File Name    

The two fields I want to import from the excel payment file are "Reference
Number" and "Amount".  
"File name" is the name of the Excel file the user is importing, "Payment
Date" will be keyed by the user.  I will use code to fill these fields in for
each record.

I don't really know where to begin, I want the user to choose the payment
file and enter the payment date and have the rest automated.

Any advice to get me started in the right direction?
Thanks,Jason