Try this:
docmd.transferspreadsheet acimport, 8, _ strtable, "c:\samples\" & strfile, False
8 is for the version of the worksheet. strtable is the name of the table your importing to. In this case it's a variable i created normally it would have "" around it. the "c:\sample\" & strfile is the path and name of the file. Once again strfile is a variable in the example, and false refers to if the worksheet has headers. There is another value you can set at the end to only import certain parts of the file. Enter a range such as "A1:g15" if you need that.