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 >
