Hi,
I have a read-only grid with a few columns, but there are quite a number of other columns from the other tables which need to be populated in excel.
I have a Data base view where I have joined all the required tables to get the data.
Can someone suggest the best way I can use the SQLServer view to get the data into excel?
Thanks in advance
Discussion posts and replies are publicly visible
Yes, I see that "Alias" doesn't accept spaces in the alias name. As a work-around can you use underscores instead of spaces, meaning your column heaer could be "Employee_ID" instead?
I proposed the same suggestion to my Business and waiting for the confirmation.