[AccessD] export to excel

Hi Pedro

I think you need to tell a bit more to get useful help.

Are you making one pivot table from data from 40000 patients?
You can in Excel attach the data from Access without importing them.

Or is it one pivot for each patient?
Do you need a graph or the only the data?
Could you make a sketch of the requested output?

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

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