Selecting file to import into Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JEB - 27 Nov 2006 01:21 GMT

I need to be able to invoke window's file directory system similar to the
GetOpenFilename method in Excel to allow my user to select which text file he
or sheet wishes to import into Access. With the GetOpenFilename method in
Excel it takes only a few statments. In searching the network for the same
thing in access it appears to be much more involved. HELP.
Thanks in advance.
JEB

Reply to this Message

John Nurick - 27 Nov 2006 07:02 GMT

Many people - I'm one of them - use and recommend the code at
www.mvps.org/access/api/api0001.htm .

>I need to be able to invoke window's file directory system similar to the
>GetOpenFilename method in Excel to allow my user to select which text file he
[quoted text clipped - 3 lines]
>Thanks in advance.
>JEB

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message