Take a look at DataMgr by Steve Bryant. Helpful tool in migrating data from various db sources. Make sure you grab the 2.2 alpha version as its the last version that supports MSAccess.
http://www.bryantwebconsulting.com/cfcs/ Otherwise: Load Candidates into query object. Load Cand_codings into another q object. loop through candidates or cand_codings records do matching logic for candidates to can_codings save the matching data you want into an array or structure end loop Finally loop through matching results and insert into search_criteria. > Hi > > I have been given the task of importing some data from one database > into another. > > The data has been imported i now need to code the individual records. > > I have three msaccess tables candidates, cand_codings and > search_criteria > > In the candidates table is field called currentposition this holds the > information i want to work with. > > The cand_codings table holds the position titles used in the new > database. > > Search_criteria tables holds, codingid (link to cand_coding), > candidateID (links to candidates). > > I some how need to loop through the candidate records, match the > currentposition field to the cand_codings and insert into > search_criteria the codingID & candidate id. > > Not sure where to start at the moment, any ideas - thank you. > > jason > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
