Yes, but I don't think your and Jim's way of doing it won't work in my application. I need to create about 100 spreadsheets. In each spreadsheet, there will be break headers, break footers with totals... I just don't understand how you could use a SQL-script and a live connection to the database to get these into the spreadsheet....
Karen > Karen the way I address this problem is like this: > > First I create a perment temporay table with an SQL-scrpit according to > my reporting needs.(with that I mean only its is a temporary table in logic > but need to be permanent so it can be accessed by ODBC. Then I in Excel > create an ODBC query to read my R:Base data base, once I have that I format > the excel accordning to my needs and save . When I need that sheet with > latest data I just press a button in excel that performs the query one time > more. (There are a few minor things in the behaviour of excel) > > Having said this I also believe that Excel-reporting has become better > since I developed my personal workaround. > > > > Gunnar Ekblad > > > >
