By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 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?

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


ADezii
Expert 5K+
P: 8,601
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

NeoPa
Expert Mod 15k+
P: 31,186
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.