Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .
I'm trying to find the connection string/parameter combination that will allow me to read from an Excel (either 2003 or 2007) file where the field contains 255 characters. I've tried the ACE string below but fields get truncated.
I was using Ole db connection to connect the excel.Then Read the data & display on it on screen and then save it to database after validation. But now excel is not getting connected via Ole db connection,as it is encrypted by some other program.
I am trying to connect XLS file and below is my connection string. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 12.0 xml;IMEX=1;HDR=Yes;ReadOnly=1;"
Hai, I am using the following as connecting string to connect to Acess 2010 databse. This is working fine in systems with windows 2007 and excel 2007, but fails when it is windows XP with excel 2003.
Need to host an excel file (2003, 2007) on a Static server. Want to be able to allow multiple users to modify the file and have the data displayed in a static web page. Is this possible?
Dear All, how to write the connection string of a file which is XML spread sheet 2003 my file named test.xml and its contains is: <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?>
Dear all, how to write the connection string of XML File which represent a Spread Sheet document
Here's the setup: MS Access has a linked table to SQL Server. SQL Server has a password on it. Trying to use Excel VBA to query this linked table in Access, but I can't get the connection string co
I need some help with code for connecting to an Excel file saved on a SharePoint server. The code works fine here Public Sub Read_Master() Dim cn As ADODB.Connection Dim adoRS As New ADODB.Recordset