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
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 comment |

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 & 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.


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 phản hồi |
1
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)


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

user1443098user1443098
4,19644 gold badges2222 silver badges4545 bronze badges
1
Add a phản hồi |
0
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


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

Post as a guest


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


*

lang-sql
Stachồng Overflow
Products
Company
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.