[AccessD] Quick Update Solution

Wortz, Charles CWortz at tea.state.tx.us
Mon May 12 14:42:26 CDT 2003


Paul,

Have you looked into the Unmatched Query Wizard?

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Paul Black [mailto:pblack at hotmail.com] 
Sent: Monday 2003 May 12 14:38
To: accessd at databaseadvisors.com
Subject: [AccessD] Quick Update Solution

Is there a quicker/better way to append data than the method I currently

use:

select all records from table 1

move to first record in table 1

loop through every record in table 2 to see if a match occurs on LINK_PT

field

If there is a match it is skipped.

If there is no match then table 1 record is appended to table 2

Move to next record in table 1 and continue loop until .eof

I can do it this way but is there another quicker solution. As the
tables 
grow the speed slows. I am using A97 for the app.

Thanks

Paul


More information about the AccessD mailing list