Hello Dave, We have been integrating Mulitvalue data to Windows, Java and the XML for many years. FusionWare has evolved with all the different standards that have been developed along the way. You have asked for a solution that the "customer without having to have a program written for each import to Excel", from this I have two suggestions. First FusionWare Relational ODBC Driver Edtion, this product was the first third party product outside of Microsoft to hit the market. It is proven and very easy to use. This option only requires FusionWare software, some of your time and Microsoft Office. The customer can issue queires directly from Excel without program intervention. The second industry standard that is newer is the .Net world, the FursionWare Direct ADO.Net and or the Reporting Services providers could be options. Please give us a call if you would like further information or visit www.fusionware.net. I am in the office on Monday at 8:00am PST. Good Luck Janet Bond 1.866.266.2326 x159
________________________________ From: [EMAIL PROTECTED] on behalf of Dave Taylor Sent: Sat 4/22/2006 12:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] Importing Data from Universe into Excel One of my customers is interested in extracting data from Universe into Excel by himself without having to have a program written for each import to Excel. If he learns the names of the files and their dictionaries, and which attributes are multi-valued, or even sub-valued, (and of course Excel), what strategies are available to him - eg. SQL commands, a macro in Excel, Web Services (next rel. of Universe), some reporting product designed to import data from Universe, etc.? The customer is considering a server upgrade using XP Pro, and I'm trying to talk him into W2003, so any strategies that would require IIS or something else that W2003 includes that is not offered by XP Pro will strengthen my argument. I am scheduled to discuss this with the customer again Monday morning about 10:00 AM Pacific Time, so any thoughts you can provide will be greatly appreciated. Many thanks, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
