Microsoft Excel Cannot Paste The Data

I had a similar issue two weeks ago where I couldn"t paste data from Squốc lộ, and the solution suggested was to lớn export it because it wasn"t possible to lớn paste that many rows (153,000).

However, I"ve sầu got a query for which the results are significantly smaller - 416 rows and 4 columns, but I still get the same "Microsoft Excel cannot paste the data" error message.

It"s possible to lớn vì chưng it from a different laptop, however.

I"ve tried lớn clear the clipboard on the máy vi tính with the problem, but that doesn"t fix it!

Has anyone else experienced this? And is there another solution, besides exporting the data?

Thanks in advance.

sql-server ssms-2014
Improve sầu this question
asked Aug 29 "18 at 12:54

Mr 2017Mr 2017
10311 gold badge33 silver badges1414 bronze badges
Add a bình luận |

3 Answers 3

Active sầu Oldest Votes
I just got this error when trying lớn copy data from a DataGridView in my winforms c# program và pasting it inkhổng lồ excel. I got around it by pasting the data inlớn Notepad++ first, then copied the data in Notepad++ và pasted it into excel.

Improve sầu this answer
answered Jan 29 "19 at 5:29

3599 bronze badges
Add a comment |
From excel, you should be able khổng lồ use MS Squốc lộ Query khổng lồ pull the data from the database inlớn an Excel table. May be easier than using the clipboard (và almost certainly faster)

Improve sầu this answer
answered Aug 29 "18 at 13:37

4,19644 gold badges2222 silver badges4545 bronze badges
Add a comment |
Maybe you can paste it into txt file, copy from it and paste khổng lồ excel. However, then you need to uses "Data To Columns" function, because excel will paste it inkhổng lồ one column.

Bạn đang xem: Microsoft excel cannot paste the data

Improve this answer
answered Aug 29 "18 at 13:05

Aliaksandr StadolnikAliaksandr Stadolnik
3133 bronze badges
Add a phản hồi |

Your Answer

Thanks for contributing an answer khổng lồ Staông xã Overflow!

Please be sure to answer the question. Provide details & giới thiệu your research!

But avoid

Asking for help, clarification, or responding lớn other answers.Making statements based on opinion; baông xã them up with references or personal experience.

Xem thêm: File Excel Quản Lý Văn Phòng Phẩm Bằng Excel, Mẫu Excel Quản Lý Văn Phòng Phẩm

To learn more, see our tips on writing great answers.

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Facebook
Sign up using Thư điện tử and Password

Post as a guest

Email Required, but never shown

Post as a guest


Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree lớn our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged sql-hệ thống ssms-2014 or ask your own question.

The Overflow Blog
Featured on Meta
How to return only the Date from a SQL Server DateTime datatype
What is the difference between varchar và nvarchar?
Export SQL query data to lớn Excel
How khổng lồ export dynamic Squốc lộ Server pivot table to excel
Copy & Paste Errors When Moving Data From SSMS khổng lồ Excel
Can't paste data from SQL inlớn Excel
“Error converting data type varchar to lớn numeric” when I export data from Excel to SQL Server using VBA
Why use .xlsx (Microsoft Excel 2016/2013/2010) tệp tin for data import instead of saving .xlsx as .xls(Microsoft Excel 97-2003)?
Hot Network Questions more hot questions

Question feed
Subscribe to RSS
Question feed To subscribe to lớn this RSS feed, copy và paste this URL inlớn your RSS reader.


Staông xã Overflow
Stachồng Exchange Network
site thiết kế / logo sản phẩm © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.6.1.39387

Staông chồng Overflow works best with JavaScript enabled

Your privacy

By clicking “Accept all cookies”, you agree Staông chồng Exchange can store cookies on your device & discchiến bại information in accordance with our Cookie Policy.