I am trying to generate a report from SSMS to Excel, using OpenRowSet.
All is working fine, still I have to export a specific column with a barcode font. I already have the column calculated from SSMS, and being exported to Excel. I also have installed the right font and I can easily use it in Excel.
I am using a template that I have designed and the designated column in Excel is already set to be using the needed barcode font, but when the export is done, the column is showing the barcode value, but not the barcode itself.
Any idea?