Make Table Query takes long time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a make table query to create a new table from
Paradox tables. There are about 80,000 records in the
Paradox tables and the process takes about 30 minutes. Is
there a faster way to do this?

Any suggestions would be greatly appreciated.

Thanks!
 
I'm using a make table query to create a new table from
Paradox tables. There are about 80,000 records in the
Paradox tables and the process takes about 30 minutes. Is
there a faster way to do this?

Any suggestions would be greatly appreciated.

Thanks!
Click to expand...

It might not help - especially if the bulk of the delay is due to
Paradox; but you might try creating an empty table with the desired
field names and datatypes, and running an Append query to load it
rather than a MakeTable query. Don't put any indexes on the table
until after it's loaded, and compact the database before and after
running the append.
 
Back
Top