TransferText Ignores Index in Import Specification
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.