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.
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.
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
And here's a link that might also provide some ideas for you: http://allenbrowne.com/ser-59.html
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.
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).
Thanks everyone I got it!
That's great! Care to share your solution with the others that read this Forum?