Newbie to API needs to take next step

[TEB2]

I'm using the API @ http://www.mvps.org/access/api/api0001.htm? and it
displaying the files in the directory that I want.

How do I then import the Excel file the user chooses?

 

[Douglas J. Steele]

Assuming the full path to the file is in strInputFileName, as in the example
at the top of that page, you'd use something like:

DoCmd.TransferSpreadsheet acImport, , "TableName", strInputFileName