Exporting to Excel

[Ket]

I have an access database which has a number of tables.

I need to perform some calculations on the data in these tables and
would like to export them to excel.

The problem is that the table contains over 500,000 rows of data. With
Excel limited to 65536 rows, what is the best way to start number
crunching the data please?

Any assistance greatly appreciated.

Thanks

Ket
London.

 

[Douglas J. Steele]

How complicated are the calculations? Can you do them in Access instead?

 

[Ket]

Doug,

Thanks for your response. I guess that some simple calcs could be done
however I need to run Pivot tables and the like.
One of my column headings in the table refers to a client code. Is it
possible to extract all the information relating to a particular
client code to excel automatically and at the same time creating a new
worksheet for each client code?
eg All the data with ABC inc as a client code is extracted to Excel.
Likewise for DEF ltd etc etc. Ideally, this would be an automatic
process rather than having to specify the code each time.

Is this the equivalent of asking to change water into wine?!

Any thoughts on this dilemma very welcome.

Thanks again for your input.

 

[Douglas J. Steele]

If you can create a query that returns the specific information in which
you're interested for a customer, you can export the query, rather than a
table.