Excel 2003 Questionssubmit your own question
External table is not in the expected format.
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(); .
Truncated Excel field data with ACE Provider
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.
Connection to Encrypted Excel File.
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.
Excel Connection: multiple-step data generated errors - .xls file
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;"
How to connect to Access 2013 database on server with excel 2003 in XP operating system
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.
Excel and static server
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?
Connect to spread sheet file (in french: Feuille de calcul Xml 2003)
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"?>
Connction string of Spread sheet document
Dear all, how to write the connection string of XML File which represent a Spread Sheet document
ADODB Connection String with Linked SQL Server Table
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
Connecting to an Excel File saved in SharePoint
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
- Load more posts