Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can I Increase Number of Records Copied to Clipboard?

Posted on 2004-08-19
4
Medium Priority
?
708 Views
Last Modified: 2008-03-10
Access is telling me that it cannot copy more than 65,000 records onto the clipboard at any one time.  I am trying to export a query into a .txt file that will have approximately 1.3 million records but only 3 fields.

Is there any way to increase the number of records that it can copy to the clipboard or is the only solution to break this into 20 different exports (1.3 mill / 65,000 = 20)

Tom
0
Comment
Question by:tawalsh3
4 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 252 total points
ID: 11846229
why copy to clipboard (and not there's no way around the error afaik)

think this will work for you directly...just modify the sql

Dim qdf As DAO.QueryDef
Set qdf = New DAO.QueryDef
qdf.Name = "MyExport"
       qdf.SQL = "SELECT * FROM myTable where Some = Something
       qdf.Close
       DoCmd.TransferText acExportDelim, , qdf.Name, outFile


0
 
LVL 39

Assisted Solution

by:stevbe
stevbe earned 248 total points
ID: 11846453
you can export any query or table directly (File --> Export). You can use code to create a query as Sid showed (you will need the Microsoft DAO 3.6x Library to do this).

Steve
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question