Failure to create index using import specification

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top