Default Indexes on TransferText Method?

Hello All,

Why does Access (2003) create indexes on importing a CSV file to a
table when using the TransferText Method in VB when the specification
name does NOT have any indexes indicated?

Similar syntax used is as follows:
DoCmd.TransferText acImportDelim, "SpecName", "TblName",
"FileNamePath", True

The specification (i.e. SpecName) has "No" indicated for indexes yet
the table created has indexes after the import is completed. A quick
look at the fields where indexes are created end with "ID", so this
may have something to do with it. Not sure but thought that I'd
mention it.

TIA!

--
Regards,

Greg Strong

Re: Default Indexes on TransferText Method?

"Greg Strong" wrote in message
news:vhftu352niud5hto8du59530t5jnb17d22@4ax.com...
> Hello All,
>
> Why does Access (2003) create indexes on importing a CSV file to a
> table when using the TransferText Method in VB when the specification
> name does NOT have any indexes indicated?
>
> Similar syntax used is as follows:
> DoCmd.TransferText acImportDelim, "SpecName", "TblName",
> "FileNamePath", True
>
> The specification (i.e. SpecName) has "No" indicated for indexes yet
> the table created has indexes after the import is completed. A quick
> look at the fields where indexes are created end with "ID", so this
> may have something to do with it. Not sure but thought that I'd
> mention it.
>
> TIA!
>
> --
> Regards,
>
> Greg Strong

Go to Tools -> Options -> Tables/Queries and check out the option 'AutoIndex
on Import/Create'...

Re: Default Indexes on TransferText Method?

On Sat, 29 Mar 2008 23:58:36 -0000, "Stuart McCall"
wrote:

>Go to Tools -> Options -> Tables/Queries and check out the option 'AutoIndex
>on Import/Create'...

Thanks! The indexes are gone on the table auto build.

Somewhat related: I received complaints on the length of time the
queries ran at the end of the month. I always used indexes to speed
things up, however when I create them I use them. In this instance
numerous indexes were created on the source tables of the tables linked.

If numerous fields are indexed but not used in the source tables and
queries are ran from another mdb file does this create overhead and
slow down the queries?

TIA!

--
Regards,

Greg Strong

Re: Default Indexes on TransferText Method?

"Greg Strong" wrote in message
news:a1g0v3t7lbb95g9ul07ff5tm55nm4sdm0q@4ax.com...
> On Sat, 29 Mar 2008 23:58:36 -0000, "Stuart McCall"
> wrote:
>
>>Go to Tools -> Options -> Tables/Queries and check out the option
>>'AutoIndex
>>on Import/Create'...
>
> Thanks! The indexes are gone on the table auto build.
>
> Somewhat related: I received complaints on the length of time the
> queries ran at the end of the month. I always used indexes to speed
> things up, however when I create them I use them. In this instance
> numerous indexes were created on the source tables of the tables linked.
>
> If numerous fields are indexed but not used in the source tables and
> queries are ran from another mdb file does this create overhead and
> slow down the queries?
>
> TIA!
>
> --
> Regards,
>
> Greg Strong

The only answer I can give is: probably. I don't know enough (ie hardly
anything) about JET internals to help with this. Perhaps someone else can
jump in?