Thank you all for your excellent help. I was able to use XML to solve this problem (or more exactly: SpreadSheetML). Now, when I want to format some SQL output into an Excel spreadsheet, all I have ...
Anybody out there ever try loading a CSV file into Excel using the Text Import Wizard? My file actually isn't CSV -- it's separated by the vertical bar character ('|'). When I load it using: ...