Dave, You may want to consider our web reporting tool Informer which allows for download to excel, pdf, and other formats. With Informer you get access to files and dictionaries via a meta file which can present the selection and output options to the end user in a friendly, easy to use fashion.
This approach also allows for security to be applied down to the field level based on user roles. It also allows you to link your files together to get data from multiple files at once. The web interface uses uniObjects for java for fast database connection, eliminating the need for ODBC setup. Give us a call at 919-848-4828 or visit us at www.entrinsik.com for more information. Brian Jackson Entrinsik, Inc. >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/