Hello,
my crystal ball says that in the months ahead there shall be many, many tables that will need to be cross-checked and verified, and that whomever designed the data structures hereabouts must’a had a lot of fun.
In order to obtain the reports I need, I could use vlookup several times in each flat-file, but I would much rather be able to load all the flatfiles into one database and just merge relevant ones by the key fields. That is, I’d like to do something which Access does just fine.
Problem: MS doesn’t want to sell me Access by itself, but only bundled. I don’t want Project, don’t want Publisher, don’t want Outlook. And I don’t want to pay for a Mercedes when I’m actually buying a moped.
Do any of you guys know of a stand-alone program that will let me load and merge csv or txt files like this without having to get a Master’s in CS or pay for six programs I don’t need?
Thank you!