Import Data

[rovert]

Hi All,

I'm having a problem when trying to import an SQL stored procedure into excel 365,

[FONT=&quot]Step 1:[/FONT] Data tab –<wbr style="box-sizing: inherit;"> > From Other Sources -> From SQL Server
[FONT=&quot]Step 2: Enter Credentials. Your server name can be an IP address
[FONT=&quot]Step 3:[/FONT] Choose any old table or view. Pick a small one because we’ll discard it later anyway.
[FONT=&quot]Step 4:[/FONT] Excel will pop up the Import Data dialog box. Click Properties here (NOT THE OK BUTTON)

I'm following the procedure above but the [/FONT]Properties are greyed out, can someone help, my workbook is not protected?

Thanks in advance

 

[ranman256]

set the CONNECTION in excel
and have it will paste into a sheet