A perfect example for beauty with the brains...

Hi

It is nice

Chears

Lalith

Geez, hectic stuff.

I’m still learning T-SQL, so most of the things used in here are a bit over my head.

My colleagues seem to think it's great, so well done.
I must agree on the previous comment posted by Anonymous on Robyn Page, extremely Intelligent and Beautiful - The perfect combination a man looks for in a woman...

Congratulations!

I am very pleased to have had the opportunity in reading this article. It is a very valuable collection of code integrating T-Sql with excel manipulating. I am also surprised as on how it got to me precisely at a time when I have to transfer data from SQL Server into Excel. Besides all of this I must refer the sharing of such valuable code on behalf of Robin Page and Phil factor. Thanks a lot and keep up the intelligent work.

Nice work.

I'm no Excel expert, but where does Excel need to be installed for this?

We don't have it installed on the same box as the SQL Server (and we probably can't get approved to get it), although I have Office 2000 with Excel installed on my client machine.

Excellent.

---

cje

Man this is sooooo timely! Thanks a bunch Robyn. Keep up the good work. I'm going to be using these examples to bring in a whole bunch of spreadsheets in to our SQL Server and to write out to Excel also. Once again, very timely!

Peace and blessings
Colin

Man this is sooooo timely! Thanks a bunch Robyn. Keep up the good work. I'm going to be using these examples to bring in a whole bunch of spreadsheets in to our SQL Server and to write out to Excel also. Once again, very timely!

Peace and blessings
Colin

Best looking tech person I have ever seen
would love to have her as a consultant

Until you do the full automation routine, you do not need to have Excel installed, as the Jet OLEDB driver is able to create, read to, or write from, excel files. When you do the automation, it will need to be on the server that has the database server on it, and the User with which SQL Server is operating must have the rights to access Excel.

For anyone who wants to extend what our Excel Automation routine does, there is a good worked example using C# at http://support.microsoft.com/kb/302084
which provides all the help you'd need to get started.

Also, Robyn, will you marry me? ;)

Bah! Nobody ever says that to me after reading my articles. :-)

nice article, never would have guessed this is possible using TSQL
what I really like to know is, what keeps you Robyn busier, certainly the above article is not at the beginner level, and being able to come up with that means a serious amount of time & eduction invested in the past, is it the acting or the programming career that you're after ?

Hakan from Canada

Hi -
Your information is great, but I have one dilemma: I sometimes want to read the FIRST sheet of a Workbook, but users often name that sheet differently (e.g. Sheet1, MySheet, Orders, etc.) and I don't know in advance what they're going to call it. Using the OPENROWSET method,
[SELECT * FROM OPENROWSET('Microsoft.Jet... ]
how can I read the first sheet of the workbook, regardless of its name? And if not by this method, what is a simple way to do it (if one exists)?
Thank you!