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
Share
Improve sầu this question
Follow
asked Aug 29 "18 at 12:54
*

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

3 Answers 3


Active sầu Oldest Votes
2
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.


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

Gharbad_The_WeakGharbad_The_Weak
3599 bronze badges
1
Add a comment |
1
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)


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

user1443098user1443098
4,19644 gold badges2222 silver badges4545 bronze badges
1
Add a comment |
0
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


Share
Improve this answer
Follow
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
Submit

Post as a guest


Name
Email Required, but never shown


Post as a guest


Name
E-Mail

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
Related
1925
How to return only the Date from a SQL Server DateTime datatype
1481
What is the difference between varchar và nvarchar?
28
Export SQL query data to lớn Excel
0
How khổng lồ export dynamic Squốc lộ Server pivot table to excel
1
Copy & Paste Errors When Moving Data From SSMS khổng lồ Excel
0
Can't paste data from SQL inlớn Excel
0
“Error converting data type varchar to lớn numeric” when I export data from Excel to SQL Server using VBA
1
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.


*

lang-sql
Staông xã Overflow
Products
Company
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.