Import selected file name to table (1 Viewer)

[rickyfong]

How can I selected some filename(s) from a selected directory in Windows environment and then import those selected filename(s) to a ACCESS Table!? Thanks!

 

[abubasil]

http://www.access-programmers.co.uk/forums/showthread.php?t=219482

 

[rickyfong]

Thanks! In fact, what I want is to import the selected filename(s) but not the file content to a table!! Any idea??

 

[JHB]

Explain a little more what exactly you want!

 

[rickyfong]

Under ACCESS, I would like to locate a filename or filenames from any directory like what I do in Windows environment (My Computer or MY PC icon). For instance,

under directory ABC, I got 3 Files, A1, A2 and A3. THen, if I only selected/highlighted the A2 and A3. Then I press a button in the ACCESS VBA programmed form, these 2 filename(s) i.e A2 and A3 would then stored to a predefined table as 2 records.

Given, the user can located any directory in the PC, therefore, the directory cannot be hardcoded in the ACCESS program!! Thanks a lot!

 

[JHB]

Below is a link to how you open the FileDialog box in MS-Access, then it is easy for you to get the file name out of it from the .SelectedItems.
http://support.microsoft.com/kb/824272