• m.schmidbauer (2/4/2009)


    Dear Gaby,

    i know this really comfortable feature and i use it a lot.

    Good to know that it also works with SQL 2008 since we are actually using SQL2005.

    But as far is i know it does not work under 64 Bit Environments because MSDASQL is not available there.

    Is this true ?

    Do you know a workaround so that spreedsheets still can be queried directly with Transact SQL under 64-Bit?

    Best Regards

    Markus

    To be honest, I'm not sure. We don't yet have any production servers in SQL 2008 yet, was mainly using the management studio portion. Anyone out there know the details on this?

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein