Kb0156: i cannot paste data into the think

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

However, I"ve 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 do it from a different máy tính, however.

I"ve sầu 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-VPS ssms-năm trước
Improve sầu this question
asked Aug 29 "18 at 12:54

Mr 2017Mr 2017
10311 gold badge33 silver badges1414 bronze badges
Add a comment |

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 & pasting it inlớn excel. I got around it by pasting the data inkhổng lồ 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 phản hồi |
From excel, you should be able to lớn use MS SQL Query khổng lồ pull the data from the database into an Excel table. May be easier than using the clipboard (and almost certainly faster)

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

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

Bạn đang xem: Kb0156: i cannot paste data into the think

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

Aliaksandr StadolnikAliaksandr Stadolnik
3133 bronze badges
Add a bình luận |

Your Answer

Thanks for contributing an answer khổng lồ Stachồng Overflow!

Please be sure khổng lồ answer the question. Provide details & mô tả your research!

But avoid

Asking for help, clarification, or responding to lớn other answers.Making statements based on opinion; back them up with references or personal experience.

Xem thêm: Hàm If Và And Trong Excel - Sử Dụng Các Hàm If Với And, Or Và Not

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 Email and Password

Post as a guest

E-Mail Required, but never shown

Post as a guest


Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy & cookie policy

Not the answer you're looking for? Browse other questions tagged sql-VPS 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 and nvarchar?
Export Squốc lộ query data lớn Excel
How to export dynamic Squốc lộ Server pivot table lớn excel
Copy và Paste Errors When Moving Data From SSMS to lớn Excel
Can't paste data from SQL into lớn Excel
“Error converting data type varchar lớn numeric” when I export data from Excel to lớn 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 into lớn your RSS reader.


Stachồng Overflow
Stachồng Exchange Network
site thiết kế / hình ảnh © 2021 Stachồng 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 Stachồng Exchange can store cookies on your device and discđại bại information in accordance with our Cookie Policy.