Select multiple files .txt/.dat for upload

[Guest_imported]

I need to allow users to be able to select multiple files from a dialog box for upload into an Access database. Can anyone shed some light.

 

[swilliams]

I do not know of a way to get the commondialog.showopen to accept multiple file selection.

You can however write your own control (ActiveX control) to do this if it is not possible

PS - do you work for datatrue??

Simon

 

[swilliams]

I have just spotted this on another thread:

You can set the Flags property of the common dialog control to do this:

CommonDialog1.Flags = cdlOFNAllowMultiselect

Then you can set the filter property to only allow selection of .txt and .dat files:

CommonDialog1.Filter = "Text Files (*.txt)|*.txt|Dat Files (*.dat)|*.dat

Then do the ShowOpen method:

CommonDialog1.ShowOpen

Simon

 

[swilliams]

forgot to close the quotes on the .Filter line in last post!!!

Simon