Anything else faster?????

[j_lyver]

I want to know is there anything else faster then the code I am using to convert a dbase file to an access. What i am doing now is that i am deleting records if a certain conditon is set from the dbase file then converting it to access 97. This is done is a loop

I commom SQL statement I am using is:

(delete the record if certain conditon is meet)
DELETE * from [bdase iv;databasepath]
.[table] WHERE num > 10

(convert the base file to access)
SELECT * into table from [bdase iv; databasepath].[table]

Is there anything fast. right it takes 15 minutes for the loop to process for 3 times.

[JHausmann]

Can't you bypass the delete and use a where condition, to exclude the records you would delete, on the select?