Importing table/ change field properties

[bstice]

hello all,

Right now, I use the macro builder to import a table from a spreadsheet (transfer spreadsheet). The problem is that I do not get to define the field properties for the table that is being imported. In the past, I used the Send Keys function to open the imported table in design view and make the changes that I need. There has to be an easier way of doing this with Access macros or VBA. Is there? Thanks in advance.

Brennan

 

[ajetrumpet]

Just curious, but the problem is that you don't want to use the send keys function here? I am not personally familiar with SendKeys, but I do know that Access assigns field properties based on the first few values that it finds in the fields upon import...

 

[bstice]

Willing to learn

I am always willing to learn more about VBA. Here is what I am trying to accomplish.

I want to change the name of a field in table "Americas Activity" from "Cost Summary Period" to "Accounting Period"

There are also several fields in the table that I would like to changed the Indexed and unicode compression fields to "yes." Thanks for your help!!!