reading file name from folder function

0

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.
 
6

'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.
Click to expand...

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.
 
6

'69 Camaro

Hi, Gerwin.
Check out the Dir function in MS Access help.
Click to expand...

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.
 
Top