I have just started working for a small bulk mail/printing company that constantly receives customer lists from various companies, usually in the form of csv files. Currently, the data is organized in file folders
-500 customer folders
-1 to 50 job folders per customer
-1 or 2 list.csv files per job
They have been using Excel and Bulk Mail Software to manipulate and sort these lists.
They want to start using Access to make appending and selecting data less tedious. Unfortunately, the lists are rarely reused, and aside from the address lines, there are few common fields among the hundreds of different customer lists.
I am wondering if undertaking is fundamentally flawed from the start, given the huge variety of columns needed for each customer and the fact that each job has a new list.