[AccessD] export to excel

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
> 
>