How to load Excel file for appending to table

[stoolpigeon]

I've successfully used, as an example, the following:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"MyTable","C:\MyFile.xls", True, "A1:B2"

However what I really need is to be able to prompt the user to find the file rather than specifying it in the code.

Really what I'm looking for is the Access equivalent of Excels getopenfilename().

Thanks for any help.

 

[Rx_]

http://www.ammara.com/access_image_faq/code/file_open_code.txt

If this older code works for you, please indicate what version of Access you are using.

http://support.microsoft.com/kb/824272
Not knowing exactly your VBA level, this one seemed to have some great step-by-step. I have not tried it, so let me know.