Query results exceed "clipboard" limit of 64K records

[Matter]

Hi All,

I think that design theory is the best location for this question;

I'm managing a very large database with around 15 years of data in it. The primary purpose of the database is to organize and archive scientific data so it can be exported for use in higher-level modeling programs. These programs do not often have the ability to query data directly from the database, so users must export the data to excel or csv - however it seems that I have maxed out the export function in Access:

One of the export queries that is used bi-weekly is in excess of 85k records, and upon attempting to export this to excel Access reports that the clipboard can only handle the first 64k records or so.

Is there a way around this? I've been using the "export as excel" function through a marco, but perhaps there is a better, more efficient way of doing this through VB?

Any ideas are appreciated. Thanks for the tips!

 

[Trevor G]

My initial thoughts would be the MACRO way either TransferSpreadsheet or OutputTo.

If you try them first to see if they give you the results you want, otherwise send me a reply and I will give you some code for ADODB to do the same.

Trevor