Yes it can be done by setting IDENTITY_INSERT ON

http://msdn.microsoft.com/en-us/library/ms188059.aspx

There are thousands of articles available on the Internet that show to achieve the same result but by using xml

http://www.mssqltips.com/tip.asp?tip=1771

I've recently used CURSOR in one of my application (unwishingly though). We were working on a survey application and we collected the data of our web forms in our custom...

Also make sure that MDAC components are installed on the machine

Plz send me the code to analyze

Hey don't get me wrong, I respect you and it was out of that respect only :)))))))))))))))))))))

I agree with everyone i definitely can't run in defiance of the facts by SSChamps and gurus infact this article doesn't need this much attention , but i'd say only...

I know that, an SSChampion won't 😀

I understand your concern Jeff, infact you made a valid point by saying that

"You can either spend time writing custom automations for all 50 users, or you can teach...

Didn't get your point my friend, are u in favour of the VBA approach coz.. it is difficult to individually teach n number of user how to use Get External...

And i guess the full support of VBA (data formatting API, [UN]limited UI) would also b there with "Get External Data", And i don't think i should've taught my users...

FOR ALL THOSE WHO GREAT FANS OF "Get External Data" my suggestion is to read the article again as the installation dependency of "microsoft query" made me write this article...

Jeez... doesn't anyone know how to use "Get External Data" on a simple view anymore

IN MSOFFICE-2000 BELOW???

SQL CLR will require sql-server 2005 only. right??? secondly, the idea of writing to a file this way shows a way to anyhow pass a "string(any big, any format, embedded...