Append Queries really, really slow

C

ChrisBat

Hi,
I am building a database that links tables directly from a DBF database;
because of conflicts between Access and the DBF application, I need to import
the data directly into a table on a regular basis. I run delete queries
first to erase the "old" data, and then import everything (unfortunately due
to the nature of the DBF application, the information on the tickets changes
sometimes hourly, so I need to reimport everything). There are 20 different
tables that I link to, and I am appending all the data onto one table for
easier manipulation and analysis. However, sometimes one of the append
queries gets "stuck" - the progress bar gets to the end but then doesn't
move. I then have to CTRL-BREAK to stop the query, and the data has not been
brought into the table. Does anyone have any suggestions as to how I can
either import the data easier, speed up the existing queries, or maybe use an
Update query to do this? (BTW, I have tried to use the update query, but it
doesn't work....maybe I'm not setting up the criteria properly).........Any
suggestions are appreciated.
Thanks,
Chris
 
Top