How To Write Excel Named Range To Sql . The documentation you mention says you can use named ranges in queries, but i've not seen any example that does this on a sheet with spaces in the name. This c# tutorial shows how to apply named range in excel.xlsx file. How To Create Name Range In Excel Complete Guide (2021) from earnandexcel.com Connecting sql to the main excel window. In the name box, type the name for your dynamic range. Joined may 28, 2014 messages 1.