Hi Dave, You can build query, pull data, format Excel worksheet automatically, and save it as �XSL file.
You can build a query directly from Excel. You should have Oterro and system ODBC or R:Base ODBC driver in single mode. In Excel Go to the tool bar Data/Get External Data/New Database Query. Then you should save it. Go to the macros and choose Start Recording. Data/Get External Data/Run Saved Query � The query will pull the data. Stop Recording Save as template � Name.xlt Excel will ask to save the template without data � Yes. When you double click on the Name.xlt from Windows Explorer the template makes the connection, pulls the data from any R:Base view, and formats the sheets. Konstantin Gudjev >From: "David Ebert" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >Subject: Views and GATEWAY >Date: Fri, 2 Aug 2002 10:59:23 -0400 > >I have a user that uses the query builder to create views. She wants to >export these to Excel. Is there any way I can capture the output of LIST >VIEW [viewname] to use GATEWAY to export the result? > >tia > >Dave Ebert > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
