Make Table Query takes long time

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!

On Mon, 24 May 2004 14:40:48 -0700,
wrote:

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!

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public