I have production data in the form of an MS Access file for each shift. There are more than 5600 of these files. I need to get all of these data into an SQL database. Obviously running the upsizing wizard on 5600 files isn't practical. I'll also have to add some fields for shift and day, etc.
I looked at this question, Q_21255773
, but it looks like that was a single Access file, with hundreds of tables. I have thousands of Access files with about 4 tables each.
Using DTS sounds intriguing, but I have no idea where to "find" DTS. In MSSMS, I can not find anything labeled Data Transformation Services or DTS.
I've gotten pretty good at VBA in Excel. I could probably put something clunky together that way, but I would prefer to do it "right".
Additionally, if I should determine that this is more work than I want to tackle, where is the best place to find someone I can hire to do this? I'm a member of Freelancer, but it doesn't seem like this is the kind of work that it is targeted at. What is the best way to describe what I am asking for so that someone with the skill set I need will know what I want?