Hello, I have an Access db (.accdb) and I have an odbc connection (64 bit) to it. The db has 3 tables.
What I need to do is to create a pivot table with data from all the 3 tables and refresh data from time to time.
Not sure about the .accdb file, probably it was created with Office 365.
In my PC I have Excel 2013 and I am trying to connect to this data source in a workbook. I can do it starting in the Excel file (using wizard that starts in the "connctions" window) or directly from "data origin" directory ("new connection" etc.). At the end a .odc file is created.
However, even if wizards above ask me about the tables I want to link (and I mark all the 3 tables) when I try to create the pivot I end up with data available from a single table.
I have no chance to add new tables, relationships and so on...
Question: am I doing something wrong or is this related to the Excel version involved (in my case Excel 2013)?
Thank you for all the comments/suggestions.
P.S. If you have good links / books to suggest on this specific topic, please do. I have been looking for good materials on Microsoft data connections, but I have not found anything good enough. For example I'd like to know if ODBC is the right choice...
F
Bookmarks