getting strange errors when importing external data to excel from SQL Server

Question

In Excel I using a Data Table that connects via a data connection string to an sql server procedure. The procedure accepts some parameters querys and then returns the data to the excel data table. This has worked well for quite a while.

Now the users have started to randomly get the following error message.

This is happening randomly as the user try's it again and it works.

Nothing else is on the spreadsheet and the returned information is well within any row count limitation that excel may have.

Check out the answers from this question. They could help. stackoverflow.com/questions/40025679/… — IceCode
– IceCode, Commented Jul 18, 2017 at 22:25
There is a video on youtube aswell :) youtube.com/watch?v=Egs-HOzNusk — IceCode
– IceCode, Commented Jul 18, 2017 at 22:28

TeleJim · Accepted Answer · 2017-07-20 21:04:14Z

1

I was able to isolate the cause of the error. If you have something on your clipboard and then refresh your table it causes a conflict when the records are returned. After clearing my clipboard and refreshing it worked fine. This most be a flaw in the version of Excel I'm using - 2016.

answered Jul 20, 2017 at 21:04

TeleJim

3175 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting strange errors when importing external data to excel from SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related