Hi all,
i want to export query output into text file by using Output macro but it showing me a message "You selected More records than copy onto the clipboard at one time". Total output is greater than 65000.
Hi all,
i want to export query output into text file by using Output macro but it showing me a message "You selected More records than copy onto the clipboard at one time". Total output is greater than 65000.
Thanx & Regards,
Naveen Pundir
Hello,
Excel 2003 only has 65,536 rows.
If you have xl'07 in compatibilty mode, you also only have 65,536 rows.
Thanx for responding.
But i'm exporting it into Text file.
any undate ...
Did you check "export data with formatting and layout"?
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
Hi,
yes it's working if i right click on table and export but i wanna export it via macro.
What command are your using to export via macro?
Hi,
Go to Macro tab>New>Output to (in action)..
I'm not useing any VBA coading.
I would give TransferText a shot.
Here is a link to microsoft on it. TransferText Macro Action
Note it is the 2007 link.
Hope this gets you there. I don't use macro's often. I use vba for similar exports.
Dan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks