compare text file against db records 
Author Message
 compare text file against db records

the task:
read from a text file, and load data in sq lserver db

the challenge:
how to determine if there is a change in the records in the text file
compared to what is in the db, to decide if to update, or insert in the db

Currently, im updating every reocrd if it changed or not.

thanks
stephane



Sun, 07 Nov 2004 18:08:38 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Text file records comparaison against a Master text file

2. Text file records comparaison against a Master text file

3. Comparing Records In 2 Text Files To Find Dupes

4. Comparing Two Text Files for Dupe Record Removal

5. Authenticating txtPassword.Text against Access DB

6. Help creating DB records from text files.

7. compare an Entry against a Table

8. comparing textBox string against pattern (LIKE??)

9. Comparing against a TimeStamp column using TSEqual() function.

10. HOW-TO?: Compare filename against "mask"

11. Text Files Comparing

12. Compare a Database Table To A Text File

 

 
Powered by phpBB® Forum Software