3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

Need Access/Excel Help, Little Problem, but i am a Newbie

by GeorgR.
2 replies
I have two CSV files,

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
#access or excel #newbie #problem
  • Profile picture of the author 2marketnow
    Ask Microsoft. They actually answer/help you.
    Signature

    Julie Gavis
    http://tinyurl.com/6cvm9qe Six Figure Income Fast

    {{ DiscussionBoard.errors[3362738].message }}
    • Profile picture of the author blackjack
      George

      You can do it very easily in Excel. If you want PM you file and I'll create a CSV or Excel file.

      You need vlookup and concatnate functions. (Vlookup to find URL and concatnate to merge PRs)

      file1

      www.mydomain.com PR1 xxxx

      File2

      www.mydomain.com CorrectPR

      so in file1, next column to xxx put vlookup to find url in file2 and bring back correct PR. Then you can combine data or leave it in the column



      Thanks
      {{ DiscussionBoard.errors[3363160].message }}

Trending Topics