• I've searched the internet high and low for a 32-bit JET driver, but can't find one, unless I'm just using the wrong search terms... Do you have a link? The other possibility is that it's already installed, although it appears inaccessible. I have a Windows 7 Enterprise 64-bit computer with SQL Server 2008 64-bit, with Office 2010 Professional Plus as well as Access 2010 installed - where all the Office products are 32-bit due to corporate standards. I don't have the option of installing the 64-bit version of Office and/or Access.

    I'm hoping to find a provider that works for OLEDB or ODBC on that SQL instance so I can import data from MS Access directly instead of via SSIS. Doing the same from within the local SQL instance doesn't appear to be possible, as I can't even use the OLEDB Provider for ODBC, as it gives me an architecture mismatch. I've installed the 32-bit version of the Access 2010 Database Engine (allegedly, ACE), but I haven't been able to see it exist beyond the listing in the Programs and Features within Control Panel, that says it's installed.

    If you have a link to a 32-bit JET driver, that will function in the 64-bit SQL instance, let me know. Any and all assistance will be appreciated...

    Steve

    (aka sgmunson)

    :w00t::w00t::w00t:

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)