Import - Coding for selecting Path/File name

  • Thread starter Thread starter Cheow Wang
  • Start date Start date
C

Cheow Wang

Hi,

I need to write codes to allow user to select the
path/file manually in order to import a text file into
Access. How should I go about coding/getting the path/file
in the program?

I do not want to use the standard import/export
functions provided my Access.

Thanks!

Rgds,
Cheow Wang.
 
Hi Cheow Wang,

Use the code at www.mvps.org/access/api/api0001.htm to invoke the
standard File Open dialog. Or if you're using Access 2002 you can use
the FileDialog() function.

Hi,

I need to write codes to allow user to select the
path/file manually in order to import a text file into
Access. How should I go about coding/getting the path/file
in the program?

I do not want to use the standard import/export
functions provided my Access.

Thanks!

Rgds,
Cheow Wang.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top