+ “;Extended Properties=\”Excel 12.0;HDR=Yes;IMEX=2\”";
But when I went to run, both XLS and XLSX connections would fail with either:
The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine.
or
The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine..
I sourced the problem to the fact that I these connection strings were trying to use 32-bit drivers, but I was on a 64-bit Sharepoint installation. After a bit of research I found that it doesnt appear there were ever any 64-bit Office 2007 drivers, but luckily there are some for 2010, and they appeared to be backward compatible.
So after downloading them from here I went to install them only to be faced with an error saying they couldnt be installed because I had pre-installed 32-bit office applications. Luckily it told me what they were (as I would have not remembered) – you may have guessed – it was Sharepoint Designer 2007.
...|
Microsoft to plug 11 holes in Office, VPN software
software includes Office XP Service Pack 3, Office 2003 Service Pack 3, Office 2007 Service Pack 2, Office for Mac 2011, and the 32-bit and 64-bit
|
|
Critical Office Hole Patched In November Release
Among the holes patched is a stack buffer overflow vulnerability that's rated critical for Office 2007, SP2 and for the 32 and 64 bit versions of Office
|
|
US-Backed Assault on Mexican Narco-Celebrities Lacks Solid Plot
Cities sued, office 2007 purchase price, historically searching and sorting surround nearby coding.. Appeal amd buy cs4 physical memory to instances around
|
|
RHEL 6: serious Linux built for growth For example, the staggering hardware capabilities - on 64-bit platforms, RHEL can scale to 128 cores and 2TB of main memory. Some might find it strange to |
|
U.S. v. JAMES See, eg, id. at 663—64. Accordingly, the district court did not abuse its discretion in admitting the testimony. Next, James argues that the district court |