Adding extra columns (that exists in Excel only) to a read-only database query


I got some great help in adding some extra columns to my database query on this thread.  The thread points to this link, which I am using. There's no real issue here as far as I'm concerned. Just curious.


When I do a data refresh (connected to single SQL Server table), I think it's re-getting all 1300+ records each time. Is there a more efficient way? Have only a connection that doesn't have to import the records and just keep the notes related to the database query in Excel? Or any other optimization I can do is welcomed. 

0 Replies