CSV Import Button

[davidjearly]

Hi,

I have the a command button on a form which has the following code on click:

DoCmd.TransferText acImportDelim, , "Patients", _
     "T:\Practice Recovery Plans\data\import.csv", -1

However, what I would like to have is to be presented with a dialog box asking me to choose a csv file to import when I click the button, rather than having to name the file 'import.csv' and stick it in that location.

Any help would be appreciated!

David

 

[namliam]

Have you tried searching the forum??

Sounds to me like you are looking for either or:
http://www.access-programmers.co.uk/forums/showthread.php?t=97787&highlight=File+Dialog

http://www.access-programmers.co.uk/forums/showthread.php?t=158308&highlight=File+Dialog

Let us know if you have more questions about this

Good luck !