Importing file names into a table?

[davetheant]

Hello everyone. I am trying to have Access 'read' the names of the files in a directory into a table that I have. I think this is possible with VBA code, but I don't know how to make the code put the data into my table. Any help is appreciated.

[nicknameoscar]

The second post in the below link seems to offer a solution (I have not done this before):

http://www.dbforums.com/microsoft-ac...ess-table.html

[RuralGuy]

And here's a link that might also provide some ideas for you: http://allenbrowne.com/ser-59.html

[davetheant]

Thanks for the response; that's exactly what I'm trying to do, however nowhere in that thread does it tell what to do with the data from the Dir() command. I just want to make each filename have its own row in my table.

[nicknameoscar]

I typed "Access VBA Dir()" into Bing and it returned lots of good sites. As I said I have never used Dir() but it appears to just return a string containing the path and file/folder name.

The site RuralGuy mentions looks good also (in case you missed his post).

[davetheant]

Thanks everyone I got it!

[RuralGuy]

That's great! Care to share your solution with the others that read this Forum?