D
dbarnes
I have setup to import tab delimited text files programmatically and the
import specifications have index on for several fields but I continue to get
some fields that don't end up with an index. I have double checked the
index settings in the specifications and certain fields will index and others
just will not do it....
Has anyone else seen this type of problem? Any suggestions? Everything is
okay except for the indices.
DoCmd.TransferText acImportDelim, "tblLISDBom Import Specification",
"tblLISDBom", "c:\tblLISDBom.txt", True, ""
Attributes DataType FieldName IndexType SkipCol SpecID Start Width
0 10 Child 1 0 3 33 16
0 10 Effect Date 0 0 3 53 12
0 4 Matl Qty 0 0 3 24 9
0 10 Parent 1 0 3 1 14
0 4 Sequence 0 0 3 15 9
0 10 U M 0 0 3 49 4
import specifications have index on for several fields but I continue to get
some fields that don't end up with an index. I have double checked the
index settings in the specifications and certain fields will index and others
just will not do it....
Has anyone else seen this type of problem? Any suggestions? Everything is
okay except for the indices.
DoCmd.TransferText acImportDelim, "tblLISDBom Import Specification",
"tblLISDBom", "c:\tblLISDBom.txt", True, ""
Attributes DataType FieldName IndexType SkipCol SpecID Start Width
0 10 Child 1 0 3 33 16
0 10 Effect Date 0 0 3 53 12
0 4 Matl Qty 0 0 3 24 9
0 10 Parent 1 0 3 1 14
0 4 Sequence 0 0 3 15 9
0 10 U M 0 0 3 49 4