[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