cmcc (8/21/2009)
My only consolation is that there seem to be so many posts about this issue both here and on other forums that they have to do something about it, right?
Dream on... MS doesn't even have 64-bit drivers for Excel yet. The 32-bit driver can't insert into a named range if there is anything under it, even if all the data will fit into the named range. Don't see them to eager to "do something about it". 🙁
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes