-
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.
-
Can't you bypass the delete and use a where condition, to exclude the records you would delete, on the select?