There are several YouTube videos to explain about how to retrieve UniVerse data from Excel using U2 ODBC client.Here are the links.
How to install 64-bit U2 ODBC client and set up a system DSNhttps://youtu.be/dNneOb3G7v0Import UniVerse Data to 64-bit Excel 365 using Microsoft Queryhttps://youtu.be/lLWcHWInA6oImporting Data To 64-bit Excel 365 from UniVerse Using 64-bit U2 ODBChttps://youtu.be/qgdKB7_GgyA
I've written a couple of programs that allow me to do what you are requesting, one produces a Tab-delimited file suitable for Excel and the other produces an Excel (XML) file which can also be opened in Excel, both can be run from the TCL passing in the sentence the filename and the dictionary field names of the file. The limitation is that it does not understands complex sentence structures, it expects the SELECTed Records to be active and acts upon that previously selected set of records.Then using wIntegrate's interface it writes it to the users PC and automatically starts Excel. Here is a sample of the EXCEL.TAB program, the one for XML (Excel) is a bit more complicated because of the need of identifying the Excel Headers and Column and Row definitions as well as Footers. but the Tab is easy to use and see what the program is doing. Hope that helps.Regards, Sam
The program won't compile because you would be missing the includes the program calls for. The CONSTANTS is an include that contains a whole bunch of items that I use in a myriad of programs, which many would not be needed for this particular program. The DIM.DICT.FILE is simply the following.DIM D.DICT.FILE(30) ; DICT.FILE.MATRIX = 30EQU DICT.FILE.TYPE TO D.DICT.FILE(001)EQU DICT.FILE.LOC TO D.DICT.FILE(002)EQU DICT.FILE.CONV TO D.DICT.FILE(003)EQU DICT.FILE.DISP.NAME TO D.DICT.FILE(004)EQU DICT.FILE.FORMAT TO D.DICT.FILE(005)EQU DICT.FILE.SNG.MLT TO D.DICT.FILE(006)EQU DICT.FILE.ASSOC TO D.DICT.FILE(007)EQU DICT.FILE.DESC TO D.DICT.FILE(008)EQU DICT.FILE.FIELD TO D.DICT.FILE(009)The other section that won't work for you is the calls to upload the file to the PC and run Excel, You're more than welcome to modify as you see fit and replace those calls with some of your own stuff.Regards, Sam