I have a macro that "Drops Table" and then "TransfersText" to build the replacement table. Can I use SetValue to set table fields - "Indexed" to "Yes (Duplicates OK)"?

Everytime I create the table I have to manually change four fields Index setting to "Yes (Duplicates OK)".

You can't do this with a macro. You need to use DAO, ADOX, or DDL to modify table structures.