Thanks for the question Steve.

Thanks for the great question Igor. I learned something today. 😀

If you're using SQL 2000 and pulling from excel, I'd recommend looking at the DTS Import/Export Wizard. Here's a couple of links to look at as a reference

http://support.microsoft.com/kb/321686

http://dbatasks.blogspot.com/2011/09/create-dts-package-to-import-excel.html

Thanks for the question, I learned something today.

twin.devil (11/17/2014)

---

Igor Micev (11/17/2014)

---

The Question came as a real case experience with a software developer, and I had to do the update in that way, ... so thought to share...

First off, let me say thank you for submitting a question. Although (to me) the wording was a little off, it was still a good "back to basics" type question....

Great question Steve, thanks!

Thanks for the great question!

Ed Wagner (11/5/2014)

---

That's what got me. Need...

I went as father time last year; however, due to time constraints and events this year I'm just going as a "DBA" so the kids can have a good time....

Thanks for the question. I learned something new today.

Thanks for the question. Good one to end the week on.

+1 It was good to learn about something brand new....

Thanks for the question!

Thanks so much for the question. Good one to end the week on.