Has anyone achieved to use ODBC connection from Excel file into Powerpivot? -


i have installed powerpivot excel 2010. don't have access 2010 thought arrange data in similar manner database.

i'm wanting query excel file has rows of self-generated data powerpivot in order perform simple pivot table. in sense attempt overview of information data set.

at moment, i'm unable set correctly odbc i'm hoping need accept excel file , powerpivot accept database excel file.

edit: come understand need set table correctly in excel odbc works correctly. picture provided right manner set table or other manner?

enter image description here

has attempted , if steps be?

thanks, peter.

peter, working on basis data in recognizable table on worksheet (and not interested in using standard excel import method through 'from other sources')

if create connection excel file in particular way possible query if database.

  • create connection spreadsheet in question in excel through data>connections>add.

  • in powerpivot window on design tab click on existing connections , find connection created. select connection , open.

  • you need name connection , offered normal import options. select sheet want table (its not important 1 choose @ point).

  • once table has been imported can re-enter setup through 'table properties' on design tab , able 'switch to' query editor @ point can not write sql query db reference other .xlsx like.

jacob


Comments

Post a Comment