How to assign new indexes in VBA

[Tony Girgenti]

Is there a way to assign indexes to the design of a table during or right
after import in VBA ?

Also, s it possible to do the following so that is uses the current database
instead of naming the database as i am doing in the following ?

DoCmd.TransferDatabase acImport, "ODBC Database",
"ODBC;DSN=CPDATAENGLISH;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=CPDATAENGLISH;
OpenMode=0;DecimalSymbol=.;;TABLE=Customer", _
acTable, "Customer", "Customer"

Any help would be greatly appreciated.

Thanks,
Tony