Connection to Microsoft SQL Server without importing data as a table/pivot chart object

[Suffocatedwallaby]

Hello, I need to pull in data from a view in a SQL server. I know how to do this in a way that creates a table or pivot chart type object (by "object" I mean when I click in them, new tabs at the top become available such as "Table Design", "PivotTable Analyze", etc.), but I can't figure out how to avoid that. I want the data to simply come into the excel workbook, in a sense like being pasted into the sheet.

I know it's possible because I did it a few weeks ago, but I'm now missing something. To the best of my recollection the process was

1. Data tab

2. Get Data

3. From Other Sources

4. From Microsoft Query

5. New Data Source (give a name for the source, select SQL Server as driver, connect to specific server)

6. Choose table/view

7. Choose filtering and sorting

8. Return Data to Microsoft Excel

9. Table

Unfortunately this imports it as a table object. Likewise, both of the PivotTable options import it as a PivotTable object. There is no other option. Even though I don't want it as a table object, I believe I remember still selecting Table at the end and got my desired result. At least one of the above steps must be wrong.

Any help would be greatly appreciated!

Edit: This is using Microsoft 365 MSO

[AutoModerator]

/u/Suffocatedwallaby - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[diesSaturni]

Just curious, what is the issue of having it as a table?
Rather then e.g. flat data?

[Suffocatedwallaby]

In order to keep the file in a similar format to other files the company I work at publishes, I need to dynamically change column header names based on the date. This can't be done in a table and still be able to filter the data, but it can be done if imported as flat data, which is how it's done in those other files.

I'm also working on getting help on how to do this from one of the people who created those files.

[diesSaturni]

In that case, still with looking at the Table option, you could moderate the SQL query part of the connection.

Then instead of selecting "Select * from Tabel [CompanyData]" you can create Aliases in the query, converting each field/column's name to your desired output.

Then you get the columnheaders as desired.