Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting data from Google Analytics

Status
Not open for further replies.
Bonediggler

Bonediggler

Technical User
Sep 20, 2007
19
US
Hello--

I need to start getting data from Google Analytics. The tool is equipped to 1)export data in CSV format as well as 2)email the csv file.

However, the format is not useable. The data I want is there, but underneath a few rows of junk (titles, etc.).

I know it is possible to pick files up off Outlook via VBA, but I'm wondering if I can also reformat the file from Access and then import.

Thanks for the help!

 
Sort by date Sort by votes
You could try the FileSystemObject and OpenTextFile.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
665
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
368
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
645
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
348
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top