When I import a text file by using the DoCmd.TransferText method with an import specification that applies an index with no replications to a field, the resulting table does not have the index and contains replications. However, when I import the text file manually using the same import specification, the resulting table contains the index. Has anyone else experienced this problem and is there a way around it so that I can programmatically import a text file to have an index field with no replications? Thanks.

There might be an easier way, but I can give you one way around it - Just import the table you like (lets say you name the new table "Customers").

'Run a distinct make table query from customers
Docmd.RunSQL "SELECT DISTINCT Field1, Field2, Field3 " _
& "into Customer_Unique from Customers"

'delete your Customer Table with Dups
CurrentDb.Execute "DROP TABLE Customers;"

'Add an index to your new table named Customer_Unique if you like
CurrentDb.Execute "CREATE UNIQUE INDEX CustID ON Customer_Unique(Field1) WITH DISALLOW NULL;"

Here you will have a Customer_Unique table "indexed" with unique records.