Comparing multi paradox files

Hello all,

Thanks in advance for any help you are able to give.

I am new to coding VBA, but think that access is going to be the
easiest way for me to compare the database files.

My problem is, I have anywhere form 5 to 250 seperate paradox files and
they have to compare across 30+ different groups. I need to compare 1
field in the file(it is in the same place for all files) with a master
list.

Here is little more detail.
Each machine and a location creates a paradox file of its settings.
Each location has different settings that need to be compared.
Need to output a single report with each machine and its differences
form the master list.

Here is how I get the paradox files, each location has a master folder
with each machine having its on folder, then then 1 paradox file for
that machine in that folder.

I have been asking around the office and some of my friends, but the
biggest problem we run into is importanting each file. I have tried
both looking at using access or excel to do this, but when I go to
import to excel it is unable to get pull anything form the file, when I
import to access I get all the data from the file.

Now each file is named the same way, but each folder is unique name
with the machine serial number.

Any help will be greatly appriciated.

.

Relevant Pages

  • Re: Lost & Found files mystery.
    ... The older CD burning software has a limit on file length. ... I then used windiff from the 98 cd to compare the cd and d ... The folder was there but no files. ... However windows 98 could not read them from the cd due to the ...
    (microsoft.public.windowsxp.general)
  • Re: Partition and Dual Boot MkII (longish)
    ... >> So you can compare yours with that layout. ... The 98 Product Recovery CD has a root dir called WIN98_SE and four sub ... I do not have the CDSAMPLE folder. ...
    (uk.people.silversurfers)
  • Re: Search non-empty rows, compare text
    ... You can't have two files with the same name in a folder. ... information in a few rows (filename, filetype, filepath, date modified, ... at the moment it assumes a new spreadsheet as it starts ... compare two columns at on each row. ...
    (microsoft.public.excel.programming)
  • Re: Name/number of Current Folder
    ... compare the EntryID of the MAPIFolder that it returns. ... Dim currentFolder As MAPIFolder ... I get the name of the Current Folder. ...
    (microsoft.public.outlook.program_vba)