I have an interesting issue. We use a CAD platform which is capable of producing textual schedules. So one CAD file may produce about 5-6 schedules. I have about 50 projects running so we end up schedules from each of the CAD files. My intention is to import these schedules in text or CSV format into a MS Access database so that I could query the data across various projects.

I was wondering if anyone might have done something along these lines and provide insights into how could I import data in mS Access residing in multiple locations and then creating a consolidated table. I do have a unique project number coming through schedules so that takes care of PK.

Will appreciate some help.