Keeping index on make table

  • Thread starter Thread starter Basil
  • Start date Start date
B

Basil

Hi,

I import a text file into my database every week. In the
import script I get it to create indexes in many of the
fields.

Once imported I run make table queries from the imported
tables thus putting the data in new tables (with a few
extra calculated fields) - I then delete the original
imported table.

Problem is that the indexes initially created do not
follow through to the new table. Is there any way I can
keep the indexes created (ideally) - or if not re-create
them automatically?

Many thanks,

Basil
 
Basil

Rather than deleting "the original imported table", could you empty it out?
That way, the next week's data would drop into an already-indexed table.
One approach would be to attach to or import the raw data, then append to
your pre-established table.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top