From: "M. Edward (Ed) Borasky" <znmeb@...>
Date: 2006-10-29T04:09:25+09:00
Subject: Re: Efficient parsing of large Excel documents in Ruby

Wes Gamble wrote:

> I am transferring this data into a SQL Server database, so perhaps I 
> could look into some M$-native method of moving this data.

Yes, there is a native way of doing this in VBA from a macro, which you
can store either in your personal macro workbook on in the spreadsheets
themselves. I have a colleague where I work that built an application
that does it.

But unfortunately, I have no idea what the technique is called. Almost
anyone who's been through some advanced Microsoft training ought to be
able to help you find it, or you might search the Microsoft knowledge
base for "efficient transfer of data to SQL Server".

If you don't have an answer by Tuesday, let me know and I'll ask her
what it's called.

And no, I don't think it involves installing CygWin. :)