Razzak, 2 Q's/Comments ... 1) My most recent RRBYWnn is 12. How do I access/download more recent versions?
2) W/re: to "pushing" data into XLS files, why not create a view or table in RB to hold the data intended for the XLS file. Then, from within Excel, "pull" the data into the worksheet via Data|[Get External Data]...\From Other Sources|Existing Connections ... (I'm using RBv8, Vista, and Excel 2007. I did this just a little while ago and it worked just fine. I had already defined the DSN/ODBC link to my RBase db - last week I even created a couple of Pivot Tables in Excel using "live" data from my RB database. I know this ain't brain surgery and I'm sure others have done this and more, but I think it's a lot cleaner than outputting to an intermediate file or re-doing your XLS import and formatting on a regular basis. I've done something like this before, but using VB(A). This time, I'm going to create a "base" worksheet, including all user-required formatting, then pull the data from RBase into it via the connection, and save it with some sort of DATETIME info in the file name for versioning purposes. At that point, it's ready for my users/report-consumers. Also, per your suggestion, I plan to look at that Report Output to XLS next week to see what that's all about. Just my $0.02, Steve in Memphis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, March 26, 2008 6:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Export Question At 05:38 PM 3/25/2008, Marco Groeneveld wrote: >If I first show all record on screen from a table I can export to Excel >and have also the fieldheader row. Here, you are using the "Export Results to..." MS Spreadsheet or Workbook that includes the results as displayed in Data Browser/Editor with column titles. >With a direct export ricght click on table it is not there. > >Is this as it should be ? Yes. Here, you are using the "Export Data to..." MS Spreadsheet or Workbook that exports the "Data" only. Notice the difference between "Export Results..." vs. "Export Data...". >Is it possible to add in a future build import and export to SQLite? Here's the best place to submit enhancement request(s) for R:BASE 9.0. http://www.rbase.com/rbg9rdcc/ >Is it possible to add in a future build import and export of all tables >with or without fields in the header. Here's how: -- Example 01 -- Exporting Data as MS Excel Spreadsheet without column names): CONNECT RRBYW15 GATEWAY EXPORT XLS CustomerList.XLS SELECT * FROM Customer + OPTION COL_NAMES OFF + |SHOW_PROGRESS ON + |MESSAGES ON + |BLANK_IF_ZERO OFF + |ACTION OPENVIEW -- Example 02 -- Exporting Data as MS Excel Spreadsheet with column names): CONNECT RRBYW15 GATEWAY EXPORT XLS CustomerList.XLS SELECT * FROM Customer + OPTION COL_NAMES ON + |SHOW_PROGRESS ON + |MESSAGES ON + |BLANK_IF_ZERO OFF + |ACTION OPENVIEW -- Example 03 -- Exporting Data as MS Excel Workbook without column names): CONNECT RRBYW15 GATEWAY EXPORT XLSW CustomerList.XLS SELECT * FROM Customer + OPTION COL_NAMES OFF + |SHOW_PROGRESS ON + |MESSAGES ON + |BLANK_IF_ZERO OFF + |ACTION OPENVIEW -- Example 04 -- Exporting Data as MS Excel Workbook with column names): CONNECT RRBYW15 GATEWAY EXPORT XLSW CustomerList.XLS SELECT * FROM Customer + OPTION COL_NAMES ON + |SHOW_PROGRESS ON + |MESSAGES ON + |BLANK_IF_ZERO OFF + |ACTION OPENVIEW That's all there is to it! Enjoy the R:BASE you have always wanted. Very Best R:egards, Razzak.
