Newbie to API needs to take next step

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TEB2 - 22 Jan 2007 18:32 GMT

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?

Reply to this Message

Douglas J. Steele - 22 Jan 2007 19:48 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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?

Reply to this Message