Changing Existing Connection to Load as Table

[julray]

Hi,

When importing data from my SQL server I chose this option;

However I want to change the existing connection so that it loads as a Table. I've searched everywhere, but can find an answer. Is this possible? If not, is there a good workaround besides having to create a duplicate connection.

Thank you!

 

[FormR]

Hi, you could try these steps..

1. Click on "Queries and Connections" on the data tab to show the queries and connections pane.
2. Right click on the query in the connection pane and choose "Load to"
3. Change as required.

 

[julray]

Hi, you could try these steps..

1. Click on "Queries and Connections" on the data tab to show the queries and connections pane.
2. Right click on the query in the connection pane and choose "Load to"
3. Change as required.

LOL, I've been working with this for years and never noticed that option before. Normally I would just choose the option to duplicate query and then choose load to table. Thank you so much for your help!