TransferDatabase questions

[Tony Girgenti]

Is it possible to do the following so that is uses the cueernt database
instead of naming it as i am diong ?

Also, is there a way to assign indexes to the tables design during or right
after import ?

DoCmd.TransferDatabase acImport, "ODBC Database", _

"ODBC;DSN=CPDATAENGLISH;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=CPDATAENGLISH;O
penMode=0;DecimalSymbol=.;;TABLE=Customer", _
acTable, "Customer", "Customer"

Thanks,
Tony