Sharepoint Connection string to Excel 2013 vs Excel 2010
I've got a weird one. I'm new to Sharepoint and connection strings, so please bear with me.
I'm connecting an Excel Spreadsheet to a Sharepoint list for RW access.
I'm using the following connection string: (I replaced the URL and list name for privacy):
I'm using the same string for writes except with an IMEX=0
Everything works perfectly in my Excel 2013 setup.
But it doesn't consistently work at our client site. They are using:
Microsoft Office Home and Business 2010 Version: 14.0.7163.5000 (32-bit)
There are 8 computers there. 5 of them work, 3 don't.
I had them check for any differences between a working computer and a non-working one. They couldn't find any difference in terms of Office versions or updates.
The 5 working computers work just fine.
The error they are getting on the 3 non-working computers is a popup that says:
Run time Error ...
Could not find installable ISAM
Any ideas? Anything I might have missed?
You should Cancel tinder plus subscription package because its totally useless
I am having the same problem.
In my case, I noticed that systems not having MS Access installed were giving the problem while connecting to SharePoint using ACE.OLEDB.
remote connect on a wifi network
Hi, my name is Marvin. I have little experience in mysql I have mysql 5.5 installed with workbench 6.1. I work with vba excel developing small applications, locally I have no problems connecting to databases.0 votes0 answersMarvin Rosal4 weeks ago
ADO connection string to a shared Excel workbok on Sharepoint
Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.0 votes0 answerszubair Aleem1 month ago
Oracle ODBC x86 and x84 on Excel 32bits.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(220.127.116.11) ODBC driver on my Excel.0 votes0 answersLucas Pott2 months ago
Connection string properties
Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?0 votes0 answersjos Clement2 months ago
Loading dbf Foxpro file from Excel VBA Project
Hi there: I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user.0 votes1 answerKlueze5 months ago
VBA update sharepoint inserts
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).0 votes3 answersThe Dinos6 months ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski6 months ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan7 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery9 months ago
Hi All, can anyone provide connectionstring for Excel 2010. I tried to set connection string for RPA Automation anywhere but it is throwing an error0 votes1 answerSiva Shanker10 months ago
- Load more posts