November 19, 2008 12:24am pst

1. SidFishes 85,858
2. Zvonko 67,790
3. gdemaria 57,490
4. _agx_ 36,592
5. Plucka 23,398
6. zadoc 22,580
7. dgrafx 20,200
8. azadisaryev 19,400
9. erikTsomik 11,500
10. msfletch 9,420
11. hielo 9,136
12. b0lsc0tt 9,132
13. Mr_Nil 7,960
14. SBennett 6,248
15. cyberdyn... 6,000
16. Yamagami 5,500
16. eszaq 5,500
18. pigmentarts 5,000
19. srikanthm... 4,252
20. Jester_48 4,200
21. rob_loren... 4,100
22. angelIII 4,000
22. HuyBD 4,000
22. digicidal 4,000
22. mwvisa1 4,000

1. mrichmon 217,323
2. SidFishes 180,877
3. pinaldave 152,619
4. gdemaria 139,719
5. _agx_ 136,427
6. dgrafx 109,722
7. trailblazzy... 95,698
8. anandkp 95,332
9. Plucka 84,009
10. Zvonko 77,940
11. Jester_48 75,737
12. mmc98dl1 70,536
13. Tacobell777 64,577
14. usachrisk... 59,028
15. SBennett 53,878
16. mkishline 43,784
17. hart 41,025
18. jyokum 38,360
19. shooksm 38,199
20. danrosent... 37,345
21. Mause 33,084
22. RCorfman 32,184
23. cheekycj 31,211
24. entrance... 29,240
25. zadoc 28,730

04.02.2007 at 06:16AM PDT, ID: 22486639

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.4

Query Existing Data, Query New Data, Append New Data

Asked by dl8453 in ColdFusion Studio, MS SQL Server

Tags: access, append, data, query

Scenario: The scenario is our employees can attend some training at the vendors facility. The training/test results are sent to us in an access mdb file. We need to update our SQL database with the test results. Any employee (userID) can take more than one course so there could be one employee with multiple titleID (course title). There will not be duplicate userID/titleID pair. testID is simple the date the test was taken and is paired with titleID.

Need: We receive an access mdb file from a vendor (A) that contains records (userID, titleID, and testDate). I need help with a query that will query our current database (B) and then query the new data (A) and update the current database (B) with any new values.

Field Names: userID, titleID, and testDate

We are using Coldfusion and SQL2000. We have the .mdb file setup as a datasource so we can directly query the mdb file. Start Free Trial

Keywords: Query Existing Data, Query New Data…

	Title
1	Append Query
2	Append Query troubles in a Training A…
3	merge mdb files - is it easily possible ?
4	Append Query
5	Append query behind form button
6	SAP training cost

Loading Advertisement...

20080716-EE-VQP-32

Query Existing Data, Query New Data, Append New Data

Asked by dl8453 in ColdFusion Studio, MS SQL Server

Tags: access, append, data, query

About this solution