Need Access/Excel Help, Little Problem, but i am a Newbie
CSV file #1 contains comma separated data like URLs, page rank and some other fields.
The second CSV file contains only two fields, URLs (the same as in the first file) and page rank. But this one is the "correct" page rank.
Today, i tried with Excel and Access to merge/import the two files, SQL queries etc...but i really couldn't figure it out.
Goal:
Update the wrong page rank values of file #1 with the right page rank values of file #2.
Eg.
Importing...
IF ( URL[1] == URL[2] ) THEN URL[1].PR =URL[2].PR )
This looks so ultra simple and i am stumped i couldnt figure it out. I might import this into a MySQL DB and try from there too.
Import
Update the
Julie Gavis
http://tinyurl.com/6cvm9qe Six Figure Income Fast