Form Creation Help Please

[graviz]

Does anyone have a good template or tutorial on creating a form to browse for a file, select a excel file and do a transfer spreadsheet command, to a table. Right now I have it hardcoded in a macro (as to a file name, and the Transferspreadsheet command, however I would like the ability to select the file in case the naming structure is different).

Here is basically what I would like it to do:

I want form with a button I can click on and it pulls up a window to select an excel or csv file from anywhere. Once the person selects it, I would only want to import columns A through BM. This data I would like put into a table called "Raw_Data" Can someone please assist me?

 

[Alisa]

http://www.mvps.org/access/api/api0001.htm
This link will show you how to allow the user to browse to a file.