Access not indexing imports - bug?

[Guest]

Hello, I searched the archives and did not see this asnwered; here is my
problem.

Every Monday I import text (csv) files into Access databases using a macro.
I have the import specifications set to import everything in the format I
need it. I also have some of the fields indexed (duplicates ok).

The problem is that the fields do not index. When I look at the resulting
table in design mode they are unindexed. and I have to manually change it to
"Yes (Duplicates OK)".

The database itself was originally an access97 database that was converted
to 2002. The import specifications were set to index after we converted.

I have tried recreating the tables, and the import specs, and they still do
not index when imported. I have also tried importing the files using vb code.

If I manually import the files using the import specs it will index the
field, but that defeats the purpose of having a macro to import the files in
the first place.

Any suggestions would be welcome. Thanks in advance.

-Bill

 

[Guest]

yeah, Thanks. I did end up having a macro that deletes the data from the
formatted tables, then imports into the blank tables. I was more or less
just curious as to why importing into a new table will not index... when you
can specify to index in the import specs.

Thanks.