I wrote an import script that imports excel files. Then it goes through and makes sure that all of the expected fields are present. After doing so, it checks to make sure the fields have the right properties. (i.e. Size, format, datatype, etc.) If not, I want it to change the setting to the correct one. This was my idea, below:
For i = 0 To .Fields.Count - 1
If .Fields(i).Name = str_SourceFLD Then
str_MatchSWX = "1"
If .Fields(i).Type = int_SourceDT Then
str_MatchSWX = str_MatchSWX & "1"
str_MatchSWX = str_MatchSWX & "0"
.Fields(i).Type = int_SourceDT
Is this possible?