O
outofbounds
hello there.
i am just learning ms access and have the following situation that i
run into day after day:
1. i download weekly csv files of google adwords, yahoo ppc and msn
ppc keyword data and google analytics web site traffic data.
2. i then want to import that data into ms access and use access as
the main data repository.
3. i assign unique keyword id's to each keyword and then can track
keywords using these unique ids.
a typical data import table might have the following fields
(date,keyword, clicks, revenue,impressions, click through rate, source
(yahoo, google, msn, etc...)
4. what i need to do is when i import the data from these various
sources, the data obviously does not have the unique keyword attribute
that i have assigned to it.
i would like to add a column to those imported tables that assigns the
keyword to its corresponding keyword ID.
the problem i have is i dont know how to do action queries very well
nor do i understand them.
how do i update or append that attribute to the imported data?
what i am trying to do right now is:
import the data table as described above.
do a select query with the imported table and the existing keyword
master table, joining the tables on the keyword phrase. then i
figured i could do an 'update query?
any help would be appreciated.
thanks
jay
i am just learning ms access and have the following situation that i
run into day after day:
1. i download weekly csv files of google adwords, yahoo ppc and msn
ppc keyword data and google analytics web site traffic data.
2. i then want to import that data into ms access and use access as
the main data repository.
3. i assign unique keyword id's to each keyword and then can track
keywords using these unique ids.
a typical data import table might have the following fields
(date,keyword, clicks, revenue,impressions, click through rate, source
(yahoo, google, msn, etc...)
4. what i need to do is when i import the data from these various
sources, the data obviously does not have the unique keyword attribute
that i have assigned to it.
i would like to add a column to those imported tables that assigns the
keyword to its corresponding keyword ID.
the problem i have is i dont know how to do action queries very well
nor do i understand them.
how do i update or append that attribute to the imported data?
what i am trying to do right now is:
import the data table as described above.
do a select query with the imported table and the existing keyword
master table, joining the tables on the keyword phrase. then i
figured i could do an 'update query?
any help would be appreciated.
thanks
jay