Retriving file names from a folder into Access table

  • Thread starter Thread starter Ralph
  • Start date Start date
R

Ralph

New Access user. Can I get file names from a folder into
an Access table?
 
This method uses DOS to build a text file.
Click on START then RUN. Enter CMD and then click OK.
This opens a DOS window.
Use CD.. to move one level up in folder structure.
Use CD <folder name> to go to lower level folder.
Use <drive letter>: to change drives.
When you are at the correct drive, use DIR to list files
and folders. Use DIR/S to list files and files in lower
folders.
Use DIR/S > Myfilelist.txt to create a text file with all
the file names.

When you finish you can click to close the window.

Some folks still use DOS.
 
New Access user. Can I get file names from a folder into
an Access table?
Click to expand...

The VBA Dir() function returns filenames; repeated calls to Dir() will
return additional filenames. You can open a recordset and loop through
it using the AddNew method to insert the names that Dir() finds. See
the VBA online help for Dir.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
import from ms access table name unknown 1
Import Multiple CSV Files Into Access 2007 1
Insert Values Of External Table Into Current Data Table 0
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Database name added to link tables! 1
Access Importing csv daily files into access 2007 1

Back
Top