CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • MySQL ODBC connection from Excel
Pages: [1]

Author Topic: MySQL ODBC connection from Excel  (Read 2942 times)

danl48

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.2.9
  • CMS version: Drupal
  • MySQL version: 5.6
  • PHP version: 5.3.27
MySQL ODBC connection from Excel
August 28, 2013, 11:28:31 am
My expertise is in business intelligence (BI) software, not in connecting to a database. I have been trying to get access to a civiCRM database (current release) with the MySQL ODBC connector from Excel (2010) without success. I can get at the data through the report modules, but cannot find the tables and fields directly.

The reason for my trying is that Microsoft has released Power Pivot as a free add-in for Excel (2010 and 2013) and it is very powerful. It can put interactive reports in the hands of users with little effort, and the cost is excellent.

While it is possible to download the data and rebuild the relationships, going directly into the database, which PowerPivot can do, would be the best method.

Can anyone help me make this connection work?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL ODBC connection from Excel
August 28, 2013, 01:45:12 pm

seems like power pivot is quite cool and useful to excel users.

seems like this is more an ODBC issue and i suspect u might get better answers / replies on a google search or on a specific mysql/odbc forum (most folks out here dont use windows)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: MySQL ODBC connection from Excel
August 28, 2013, 06:13:59 pm
Haven't looked at odbc to mysql in years but I vaguely remember having to set one of the advanced settings (maybe character set)? But yes this is probably an odbc/mysql specific question.

Fortunately most of the data I deal with is small enough that the regular pivot table on a csv export works fine, combined with a macro to make it easier for users to create the pivot.

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: MySQL ODBC connection from Excel
August 28, 2013, 07:48:56 pm
If you do find the answer by asking on a different (MySQL) forum, I would appreciate it if you posted back here with a link to the answer.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • MySQL ODBC connection from Excel

This forum was archived on 2017-11-26.