Cannot see the SQL query designer

neoambrose

New Member
Joined
May 2, 2013
Messages
1
I am new to theis forum and I have carefully searched other posts and no one seems to have the same problem I have.

I'm new to the powerpivot scene but I've been working side by side with Excel and Access for quite a long time. I'm following a book about powerpivot and the tool is really getting more attractive by the day. According to the book, there is SQL query designer built in that substitutes the old MS Query and can be accessed when importing tables.

I follow the procedure and when aI hit 'design' I get this window:

05.02.2013-11.46.19.png



when I'm supposed to get this one, according to the book and tutorials I've read:

05.02.2013-11.47.37.png


Does anyone know why I'm getting this? Does it have to do with the fact I'm importing an access database?

I'm sorry if this is a very rookie question but it really has me puzzled, thanks in advance for your comments.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,214,859
Messages
6,121,963
Members
449,059
Latest member
oculus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top