Hello
I'm looking at 10-12 different price catalogues/files, the pricefiles come in different layouts (columns/fieldnames) and different filetypes: csv, txt and xml. I need to compare the files with each other based on a unique modelname found in each of them, and thereby locating the cheapest among other things.
My problem is this, the files are looking to be updated, perhaps every week or so, but will always remain in the same location (so new files overwrite old ones with the same name). In order to start this process this the best, I'm looking for how I should approach this.
Will it make sense to link the data instead of adding it as a table? Will that work if a new file is overwriting the old one? I'm just thinking of doing some VBA along with Queries in order to find the data I want, but if there is something better suggested I'm all ears.
The files vary in size around 10-50 mb each, so there are a lot of rows of data in them.
Any help would be much appreciated.