By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,447 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

Exporting Large Amounts of Data to a text file

P: 1
When I try to export results from a query (about 300,00 rows)to a .txt file in ACCESS 2007, I get an error message that the clip board can exceed 64 rows.

Is there a way of getting around this?

Jan 29 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,638
You can manually Export the Data (Comma Delimited) using VBA Code. Post the SQL for the Query so that we can have a look.
Jan 30 '10 #2

Expert Mod 15k+
P: 31,494
What method are you using in your attempt to export the data?

In whichever method that is, are you sure it is 64 rows rather than 64K?
Jan 30 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.