[AccessD] export to excel

Hi Michael,

thanks but i don't have MS Analysis Services 

Pedro Janssen


In antwoord op:

> From: "Michael Maddison" <michael.maddison at ddisolutions.com.au>
> To: <accessd at databaseadvisors.com>
> Date: Wed, 19 Feb 2003 22:55:25 +1100
> Subject: RE: [AccessD] export to excel
> 
> 
> Pedro,
> 
> You can have a look at crosstabs in Access (just be careful with your
> functions ;-)
> On the other hand if you have MS Analysis Services available to you
> (comes with SQL Server) it sounds like
> just the thing for you.
> 
> cheers
> 
> Michael M
> 
> 
> Hello Gustav,
> 
> there are more then 40000 patients. That are a lot of sheets.
> I don't know how to make a pivot table in access with percentages(%).
> That's why i wanted to the calculations in access.
> 
> Pedro
> 
> 
> 
> 
> In antwoord op:
> 
> > From: Gustav Brock <gustav at cactus.dk>
> > To: "pedro at plex.nl" <accessd at databaseadvisors.com>
> > Date: Wed, 19 Feb 2003 11:35:22 +0100
> > Subject: Re: [AccessD] export to excel
> > 
> > 
> > Hi Pedro
> > 
> > 1. Import one patient per sheet.
> > 2. In Excel, attach data from one patient at the time.
> > 3. Why don't you perform those calculations in Access?
> > Remember: Excel is not a database (quotation from Microsoft).
> > 
> > /gustav
> > 
> > > i have a table with about 550000 records. I need to import these 
> > > into excel to do some calculations. Excel thought, only can handle 
> > > 65536 rows per sheet. Is there a way to import from Excel or export 
> > > from access these 550000 records, in an easy way, divided over 
> > > several sheets, taking into account that records that are the same 
> > > from the field Patient, may not be divided over different sheets.
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>