mjt
03-16-05, 04:21 PM
I'm having difficulty with what on the face of it seems to be a simple task...
I have created an Access table that is used to store information for a delimited text import. There are 2 steps in my import process.
First, I clean out all of the existing records from the table using the SQL "DELETE FROM [TABLE]" command.
Second, I append the new records from the text file using the SQL "INSERT INTO ......" command.
The strange thing is if I put a STOP after the DELETE FROM command and then continue to run the program everything works perfectly. However, if I just run the function withouth the STOP command not all of the records appear in the table. It almost appears that the DELETE commad is still running when the INSERT command begins and this deletes some of the new records. Any thoughts?
I have created an Access table that is used to store information for a delimited text import. There are 2 steps in my import process.
First, I clean out all of the existing records from the table using the SQL "DELETE FROM [TABLE]" command.
Second, I append the new records from the text file using the SQL "INSERT INTO ......" command.
The strange thing is if I put a STOP after the DELETE FROM command and then continue to run the program everything works perfectly. However, if I just run the function withouth the STOP command not all of the records appear in the table. It almost appears that the DELETE commad is still running when the INSERT command begins and this deletes some of the new records. Any thoughts?