How to let user specify filename before importing?

Y

Yeo Eng Ann

Hi,

I am trying to create a import sequence in access 2000
where the user will select a filename and my program will
import the file into a table.

I am using the docmd.transfertext method but I need the
user to specify the filename instead of hardcoding it. How
do I show the users the same "Open file dialog box" which
we see when we import manually?


Please help.

Thank you.

Yeo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import a file using a field on a form 0
Importing excel table but user to select table in macro 4
copy filenames in a folder to a table 3
Link or Import Data from Excel to Access 2
Verify file exists before executing TransferText 2
Verify file exists before executing TransferText 2
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Import CSV Type Conversion Failure 3

Top