Keyword Report XML into MS Access

16 views
Skip to first unread message

Schwornje

unread,
Feb 27, 2006, 1:42:25 PM2/27/06
to AdWords API Forum
I've been able to connect to the API using Perl and download a keyword
report. Now I have to get that data into a Microsoft Access DB. I have
minimal experience with XML and trying to sort out the XSLT that I need
to create to get the XML into Access is driving me batty.

Anyone have a basic schema for the keyword reports? Or perhaps, are
there suggestions for other methods I could use to get the data ready
for import? I found one example on the forums of a Perl script for
converting to a .csv file, but was unable to get it to work.

Our typical process is to get a .tsv from the UI, then import it to the
database. It works fine, but I figure why not automate the process?
Turns out the water was deeper than I expected.

PPCBidTracker

unread,
Mar 8, 2006, 1:59:21 AM3/8/06
to AdWords API Forum
Just use an XML parser......

Reply all
Reply to author
Forward
0 new messages