October 29, 2007 at 3:41 am
Hi,
Can anyone help me with the following problem, i am running a excel macro which is connected to SQL 2000 server and occasionally it works ok but also occasionally i get the following error message
Run-Time Error '-214721871(80040e31)' timeout expired
Joe
October 29, 2007 at 4:09 am
Hey,
Try these links which helps in performance better for data transformation from Xcel to Sql....
http://www.excel-db.net/help/features.htm
msdn2.microsoft.com/library/aa203746(office.11).aspx
http://www.sqlmag.com/Article/ArticleID/38905/sql_server_38905.html
search.techrepublic.com.com/search/Microsoft+Excel.html
October 30, 2007 at 7:32 am
fixed it by changing back for sql sp4 to sql sp3
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy