Uppercase column names with VBA or Macro?

[ranchan02]

Hi Everyone:

I have a project of migrating our Access data to Oracle. One of the pre-reqs the boss wants is to uppercase all of the column names (Field name) for all of the tables. I want to avoid manually going in all the tables and changing the case of the columns because there is like 300 tables where dealing with. I was wondering if in Access..is there an efficient way of converting my column names to upper case via script? VBA or Macro?

 

[KenHigg]

Seems your boss has an obfuscated set of priorities

 

[Pat Hartman]

What a silly waste of time. I suppose if you had to do it, you could use the fields collection of the tabledefs collection. Write a code loop that uses the UCase() function to convert each name.