[AccessD] export to excel

Gustav Brock gustav at cactus.dk
Wed Feb 19 04:36:00 CST 2003


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.




More information about the AccessD mailing list