Deduplication of a sort

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
 
J

Jeff Boyce

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
 
A

Alex

Yes my problem is I am trying to find a way to import the file names into
an acess table

Alex
 
J

Jeff Boyce

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
 
K

KARL DEWEY

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

Alex

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