Select PC drives from listbox to import?

[Randy]

Is there a way to select available drives (Floppy A:\, C:\, D:\ etc.) from
lets say a list box placed on a form. The idea is to select exel files that
could be on drive A\, C:, D: etc. and then select the excel file and import
the selected file to my table? I know how to File, get External Data,
Import etc. I need to automate the process. Thanks Randy

 

[Damien]

I reckon you want the CommonDialog Active X control.

Have a look on Google for Access CommonDialog or try this
web address:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;303066

Damien