Access equilivant to Excel "Application.GetOpenFilename"

[greybeard]

I need to parse some raw text files and do some processing before creating records.  I wrote a routine in VBA as an Excel macro, but the resulting file excedes 65,000 records.  I converted to Access, it works, except for the dialog box to select the input file.  In Excel, I used "Application.GetOpenFilename".  What is the equilivant in Access?

 

[Quehay]

This example is from the Samples folder of Office. It gives you reference to the Access application object. Can you take it from here?

MICROSOFT ACCESS
This example returns the location of the Microsoft Access sample databases.

"Sub MS_Access()
Dim AccDir As String
Dim acc As Object
'OLE automation to Access
Set acc = CreateObject(""access.application"&quot
'Return the path for msaccess.exe
AccDir = acc.SysCmd(Action:=acSysCmdAccessDir)
'Display the path
MsgBox ""MSAccess.exe is located in "" & AccDir
'Free up variable storage space
Set acc = Nothing
End Sub"