Deduplication of a sort

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi, I have a real problem:

1. I have a table with 2000 records where one field contains the name of a
picture file.
2. I have a folder containing the 2000 picture files.

My problem is that we have found instances where the file names do not tie
up and I need to sort the mess out.

Is there a way where I can read the file names in Access table and then do a
find unmatched between the two table fields?

Many thanks

Alex
 
Alex

If you have two Access tables, you could start the query wizard and select
the "Find Unmatched..." wizard.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes my problem is I am trying to find a way to import the file names into
an acess table

Alex
 
Alex

How are you at VBA/coding? I'm fairly sure you could write a procedure that
stepped through all the filenames in a directory and wrote them to a
recordset/table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You can create a text file to import.

Click on windows START - Run and type in CMD. This brings up a DOS window.
It will default to C:\Documents and Settings\Your User Name.
Use the command CD\ and press ENTER to get to the root directory if
you files are on the C:drive. If they are on another drive then type in the
drive letter followed by a colon like this F: and then press ENTER.
Then CD and the folder name where the files are located. You will need to
tranverse one folder layer at a time.

Then use the command DIR to see the file listing. Then use the command
DIR /B >MyFileList.TXT to create the text file containing all files in
that directory. The /B only list the filenames with extention. If you
want size and other information omit it. If you also have files in
subdirectories the you can get them all by including a switch for
subdirectories like this --
DIR /S /B >MyFileList.TXT
When you finish close the DOS window. Import the text file.
 
Thanks Both - that worked a treat KArl !

Alex

KARL DEWEY said:
You can create a text file to import.

Click on windows START - Run and type in CMD. This brings up a DOS
window.
It will default to C:\Documents and Settings\Your User Name.
Use the command CD\ and press ENTER to get to the root directory if
you files are on the C:drive. If they are on another drive then type in
the
drive letter followed by a colon like this F: and then press ENTER.
Then CD and the folder name where the files are located. You will need to
tranverse one folder layer at a time.

Then use the command DIR to see the file listing. Then use the
command
DIR /B >MyFileList.TXT to create the text file containing all files in
that directory. The /B only list the filenames with extention. If you
want size and other information omit it. If you also have files in
subdirectories the you can get them all by including a switch for
subdirectories like this --
DIR /S /B >MyFileList.TXT
When you finish close the DOS window. Import the text file.
Click to expand...
 
Back
Top