reading file name from folder function

[00ScarlettJohnson]

I am using Access 97. Just wonder if there is a fuction which can read all
the file name from a folder and put it to a column in a table. Please let me
know. Thanks.

 

['69 Camaro]

Hi.

I am using Access 97. Just wonder if there is a fuction which can read all
the file name from a folder and put it to a column in a table.

Please see the getFileInfo( ) function in the tip, "How to compare the
contents of two directories," on the following Web page for an example:

http://www.access.qbuilt.com/html/vba1.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Check out the Dir function in MS Access help.

 

['69 Camaro]

Hi, Gerwin.

Check out the Dir function in MS Access help.

The Dir function doesn't store the file name in a table. The getFileInfo( )
function on that Web page does -- after using the Dir function to read the
file names in the directory.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.