I wrestled with this for quite awhile. I ended up doing a very manual thing. I blogged about it here

http://www.prd-software.com/blogs/entryid/60/importing-or-converting-microsoft-excel-data-into-sql-server.aspx

Hope it helps someone.

Rod