Home Forums SQL Server 2005 Development Bulk insert from file having varying number of columns RE: Bulk insert from file having varying number of columns

  • Re: 64-bit ACE & 32-bit Office apps...

    If you install this, and you have 32-bit Office apps, it will probably mess things up for the Office apps. At least that's been my experience with 32-bit Office 2010 apps on 64-bit Windows 7.0. I wanted to work within 64-bit SQLExpress 2008R2, and thus installed 64-bit ACE engine (with the switch to do so), and it did indeed make the 64-bit ACE engine visible to SQL Express, but then...

    Excel 2010 - wanted to reinstall/reconfigure each start (and it made PowerQuery unavailable...)

    Project 2010 - wanted to reinstall/reconfigure, then failed ("out of memory"...really?)

    Word 2010 - wanted to reinstall, but the NoReReg=1 registry change worked for Word.

    "NoReReg = 1" did not work for Excel or Project...

    So..... I installed 32-bit SQL Express, uninstalled 64-bit ACE, and... Office apps are OK now.

    Reinstalled PowerQuery just to be safe.

    On a 64-bit SQL Server box, having 32-bit and 64-bit ACE installed, seemed to work... the 32-bit ACE engine is not visible to SQL Server, but the 64-bit engine will be.