A little background: I worked monthly with 24 individual files which I ultimately append together in IDEA but when I import all of them they don't always import with the consistent field types (e.g. character, numeric, etc.). Therefore I end up having to go into each of the files and update accordingly so I can then append them all.
I created a macro to run through every field within a file and change the field type to what I've specified but as it's currently scripted I have to run it individually over each active database. Is there script that I can add to the beginning of this that it will loop through every file within my IDEA project folder?
Last seen: 1 year 5 months ago
Joined: 04/14/2017 - 14:46