You are correct Karen. Before the advent or R:Charts, I used to get data from R:Base directly from a spreadsheet in order to generate graphs. TTBOMK, Excel will NOT see temporary tables,. What I did was create a permanent database table, populate it with the desired data, launch an Excel spreadsheet that ran a macro that updated the data.much easier with R;Charts.
Javier, Javier Valencia 913-915-3137 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 04, 2008 8:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Printing to Excel File I don't think Excel will be able to "see" a temp table, although I admit I haven't tried it. You might have to try a permanent table. In Excel 2002, you go to "data", "import external data". It does work really well. I've taught several of my clients how to attach to RBase tables and create their own spreadsheets. Steve, Thanks for your input. Of course my the Excel on my XP machine does not have the Query option and I think its Office 2002. I tried it on my Vista laptop with the new Excel (2007), which does have the Query, but when I go to select columns to include, it is a view and does not list any columns! (I built my view to only include current members and to eliminate billing addresses that were the same as the street addresses.) I might could create a temp table to achieve the same result. Will give that a try. Your $0.02 is always appreciated!!! Jan in Charlotte
