EXCEL Import Data Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

EXCEL Import Data Query

Author

Topic

sureshkumarnaidu
Starting Member

3 Posts

Posted - 2007-12-11 : 06:35:53

Hi All,

Iam trying to import data from Excel using Import Data query which has 125 columns. iam getting an error message
"microsoft ODBC SQL Server Driver Protocol error in TDS Stream"

Pls help me

Urgent

Advances thanks

Regards
Suresh

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2007-12-11 : 06:45:16

I think there is a limt of 25 columns when using this.

Check this link: http://forums.aspfree.com/microsoft-sql-server-14/protocol-error-in-tds-stream-39882.html

Duane.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-11 : 06:46:02

This is a forum for WORKING scripts only.
Your problem is described here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
even though the header says "Export".

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources